API Help Needed

[DMacauely]

I'm trying to get our Affiliate Marketing system (PushLap) to talk to the system we use for our online forms, billing, & invoicing (SuiteDash) and have run into a snag.

Here is the workflow that I'm trying to achieve:

• Step 1. Trigger: New Contact created in SuiteDash
• Step 2. Pabbly API requests data from PushLap for all referrals submitted by affiliate program participants
• Step 3. Pabbly compares emails returned from PushLap (that ere submitted by affiliate partners) with the email used to create the new user in SuiteDash
• Step 4. Pabbly then uses a router to determine
  • If No match exists, - end workflow (do nothing)
  • If Match exists use API (Put) to:
    • Push the unique SuiteDash ID (Uid) gathered in Step 1 over to PushLap's external ID field (referredUserExternalId)
    • Update referral status within PushLap system from inactive to active

I've been able to accomplish steps 1 & 2 but I'm getting stuck at step 3 because I don't know how to process the data that the API sends back in step 2.

• When the data comes back from via the API, it is in the form of a list of unique labels and their associated values such that the names & emails appear in the format below (see screen shots) with the response getting longer or shorter based on however many affiliate redords PushLap has at the time of the API Call in step 2
  • Label: 0 Email, Value: [email protected]
  • Label: 1 Email, Value: [email protected]
  • Label: 3 Email, Value: [email protected]
  • Label: X Email, Value: [email protected]
• I believe there is way to use a JavaScrip for step 3 (such as the code below) to accomplish my desired workflow but I don't think Pabbly allows me to assign the entire API response from step 2 as a variable within the code.
  • In all of the Pabbly Code tutorials that I've watched so far (such as this one), they are working with variables that use a static label and and data that changes based on the parameters within the API call.
    • In my situation though, I'm using the API to retrieve a list that will vary in lenth as referrals are added and where each person on that list will have a unique label and associated value for their email
      • Without the ability to assign the entire API response from step 2 as my variable within my JavaScrip, I'm not sure how to do what I need to do...
      • • let referrals = {{PushLapAPI.response}}; // Inserted variable for the full referrals object
          let newContactEmail = {{SuiteDashTrigger.email}}; // Inserted variable for the new contact's email
          
          let matchFound = false;
          let matchedLabel = null;
          
          for (let key in referrals) {
          if (
          referrals.hasOwnProperty(key) &&
          typeof referrals[key] === "string" &&
          referrals[key].toLowerCase() === newContactEmail.toLowerCase()
          ) {
          matchFound = true;
          matchedLabel = key;
          break;
          }
          }
          
          output = {
          matchFound: matchFound,
          matchedLabel: matchedLabel
          };
          
          return output;

Any ideas or better ways to tackle this one?

 

[DMacauely]

After thinking about this some more I found another way to structure the workflow that's gotten me a little bit further, but I still get stuck.

Here is the revised workflow that I'm trying to achieve:

• Step 1: Trigger: SuiteDash sends webhook to Pabbly upon form submission
• Step 2: Pabbly API requests data from PushLap for all referrals submitted by affiliate program participants ("simple response" NOT selected so that data is recieved as a single array
• Step 3: Pabbly filter PushLap API data aray from restep 2 to ensure that it contains the email address sent via SuiteDash webhook in step 1
  • If No match exists, end workflow (do nothing)
  • If Match exists continue workflow:
• Step 4: Use JSON extractor to convert step 2 array into format that camp be mapped
  • There are 17 data labels and unique values for each PushLap referral record

I've successfully gotten my workflow to execute through step 4, but I'm not sure how to execute the rest of what I'm trying to do:

• Step 5: Figure out how to isolate the unique set of 17 data labels and their associated values that relate to the email sent from SuitDash in step 1
  • Crital identifiers that must be isolated so that it can used later:
    • the unique PushLap ID of the affiliate who made the origianl referral (affiliateId) to be retrieved via API GET command
    • the unique PushLap ID of the referral to be retrieved (id) via API GET command
      • This is the same value to be used with a different label (referralId) when updating an existing referral via API Post command Lap

• Step 6: Utilize unique values isolated in step 5 to equip Pabbly API to post the following values to PushLap
  • Update Referrals (Put)
    • Push unique SuiteDash ID (Uid) gathered in Step 1 over to PushLap's external ID field (referredUserExternalId)
    • Update referral status within PushLap system from inactive to active

If anyone can offer any tips on how to tackle steps 5 & 6 I would be eternally grateful.

Thanks!

 

[Preeti Paryani]

Hello @DMacauely,

Could you please provide us with the Workflow URL where you are facing this issue? This will help us investigate the problem more effectively and assist you accordingly.

Please be aware that to assist you effectively, we may need to access your Pabbly Connect account. If you're comfortable with this, please grant us permission by stating in your next reply:

"You have my permission to log into my Pabbly Connect account and edit the workflow, if required. Here is the registered email address associated with it."

Looking forward to assisting you further.

 

[DMacauely]

Hello @DMacauely,

Could you please provide us with the Workflow URL where you are facing this issue? This will help us investigate the problem more effectively and assist you accordingly.

Please be aware that to assist you effectively, we may need to access your Pabbly Connect account. If you're comfortable with this, please grant us permission by stating in your next reply:

"You have my permission to log into my Pabbly Connect account and edit the workflow, if required. Here is the registered email address associated with it."

Looking forward to assisting you further.

Hi Preeti,
Here is the URL associated with the work flow: https://connect.pabbly.com/v2/app/workflow/mapping/IjU3NjYwNTZhMDYzMTA0MzQ1MjY0NTUzZDUxMzUi_pc

Since you work for Pabbly you certainly have my permission access my Pabbly Connect account to help me and edit the workflow, if required. The email address associated with this workflow is [email protected]

Thank you very much!