Custom Coded Workflow Using Custom Objects

[MCarr2]

Hi everyone,

We currently use an integration called Subskribe to manage all of our subscriptions (SaaS).

The Subscriptions custom object information is:
objectTypeId: 2-21331959
internal name: subskribe_subscription
fullyQualifiedName: p8086137_subskribe_subscription

I have created a workflow with a custom coded step that counts the number of associated subscriptions with:
1. Less than 365 days remaining and
2. Has the EP Subscription Product (internal name: ep_product) property set to "EP for School".

The property that contains the remaining subscription duration is "Remaining Subscription Duration" (internal name: remaining_subscription_duration) and it is on the Subscription object.

The property I want to populate is on the native Company object and is called "Count of EP Subs < 1 Yr" (internal name: count_of_subs_max_1yr). I have a step in the workflow after the custom coded action that is populated with the output from the script.

My API secret is called "API_KEY" and all options are selected in the private app area.

When I test my workflow with a customer, it appears to be working but when I manually enroll the customer into the workflow, it's not updating the Count of EP Subs < 1 Yr property.

The log when I test the script produces the following:

2024-12-02T08:34:32.241Z	INFO	Received companyId: 5376244591
2024-12-02T08:34:32.293Z	INFO	Fetching associated subscriptions for company: 5376244591

 Here is the script:

const hubspot = require('@hubspot/api-client');

const hubspotClient = new hubspot.Client({ apiKey: "API_KEY" });

// The main function should be async
exports.main = async (event) => {
  const companyId = event.object.objectId;  // Correct reference to companyId

  console.log('Received companyId:', companyId);  // Log to confirm

  try {
    if (!companyId) {
      return {
        output: {
          message: 'Error: Company ID is not available in the event object.'
        }
      };
    }

    console.log(`Fetching associated subscriptions for company: ${companyId}`);

    const associatedSubscriptions = await hubspotClient.crm.associations.getAll(
      'company',
      companyId,
      'subskribe_subscription'
    );

    console.log('Associated Subscriptions:', associatedSubscriptions);  // Log the associated subscriptions

    let count = 0;

    for (const association of associatedSubscriptions) {
      const subscriptionId = association.id;

      const subscription = await hubspotClient.crm.objects.basicApi.getById(
        '2-21331959', // subscription objectTypeId
        subscriptionId
      );

      console.log('Fetched subscription properties:', subscription.properties);

      const remainingSubscriptionDuration = subscription.properties.remaining_subscription_duration;
      const epProduct = subscription.properties.ep_product;

      if (remainingSubscriptionDuration < 365 && epProduct === "EP for School") {
        count++;
      }
    }

    console.log(`Count of matching subscriptions: ${count}`);

    await hubspotClient.crm.objects.basicApi.update(
      'companies',
      companyId,
      {
        properties: {
          count_of_subs_max_1yr: count.toString() // Ensure count is a string
        }
      }
    ).then(response => {
  console.log('Update response:', response);  // Log the response for debugging
}).catch(error => {
  console.log('Error updating property:', error.message);  // Log any error during the update
});

    return {
      output: {
        message: `Successfully updated 'Count of EP Subs < 1 Yr' to ${count} for Company ID: ${companyId}`
      }
    };
  } catch (error) {
    return {
      output: {
        message: `Error occurred: ${error.message}`
      }
    };
  }
};

I'm at a loss as to what is going wrong and hoping someone can assist! Thanks in advance for the help!

[PamCotton]

Hey @MCarr2, thank you for posting in our Community!

It sounds like your workflow is on the right track! To ensure it works as intended, confirm that your custom coded action retrieves and filters the associated subscriptions correctly. The output should reflect the count of subscriptions meeting your criteria. Then, ensure the workflow step updates the "Count of EP Subs < 1 Yr" property on the Company object with this value.

To our top experts @Anton and @DanielSanchez do you have any other recommendations for @MCarr2?

Thank you,

Pam