Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Help with a trigger on nested array string value

  • January 11, 2023
  • 4 replies
  • 240 views
K
  • KJABeginner
  • Beginner
  • 2 replies

I’m trying to setup a custom Zapier app to a CRM system with an existing API, to monitor “Jobs” for a change to a specific status value. But the value I need to poll on for the trigger is in a nested JSON array.

The JSON response from the API is as follows:

[
  {
    "id": 987654321,
    "jobNumber": "12345",
    "projectId": null,
    "customerId": 4567890,
    "locationId": 2345678,
    "jobStatus": "Completed",
    "completedOn": "2023-01-07T02:08:09.972Z",
    "businessUnitId": 123,
    "jobTypeId": 1098765,
    "priority": "Urgent",
    "campaignId": 3573028,
    "summary": "This is a test",
    "customFields": [
      {
        "typeId": 11111111,
        "name": "Auto-Sync Status",
        "value": "Hold Sync"
      }
    ],
    "notificationsEnabled": true,
    "createdOn": "2023-01-06T21:40:18.547645Z",
    "createdById": 905124,
    "modifiedOn": "2023-01-11T01:40:08.5405171Z",
    "leadCallId": null,
    "bookingId": null,
    "soldById": null,
    "externalData": null
  }
]

My custom code in the Zapier app trigger API endpoint code is:

const options = {
  url: `https://api.url/${api_user}/jobs`,
  method: 'GET',
  headers: {
    'Accept': 'application/json',
    'Authorization': access_token,
    'App-Key': '12jod9823hdu293djoq9'
  }
}

return z.request(options)
  .then((response) => {
    response.throwForStatus();
    const results = response.json;

    const jobs = results["data"].map((item) => {
    return Object.assign(item, {
      id: item["id"]
      });
    });

    return jobs;
  });

 

 

The string value I need to check/trigger on with Zapier is the customFields > value

How could I configure the custom code to read a user input value from the input designer, and return the jobs matching the input value?

 

Thanks :)

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @KJA 

Good question.

Perhaps consider a different approach.

Use a Zap with a Webhooks Retrieve Poll trigger step: https://zapier.com/apps/webhook/help

Then follow that with a Filter step: https://zapier.com/apps/filter/help

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Liz_Roberts
1 person likes this
  • Liz_Roberts
    Liz_Roberts
K
  • KJABeginner
  • Author
  • Beginner
  • 2 replies
  • January 13, 2023
Troy Tessalone wrote:

Hi @KJA 

Good question.

Perhaps consider a different approach.

Use a Zap with a Webhooks Retrieve Poll trigger step: https://zapier.com/apps/webhook/help

Then follow that with a Filter step: https://zapier.com/apps/filter/help

 

Hi Troy,

Thanks for the suggestion.

I haven’t thoroughly looked into how webhooks work, but from first glance of attempting to configure a zap, I don’t think I can use webhooks as the URL/endpoint of the CRM API is dynamic and contains values set by the custom app oauth authentication/access tokens.

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • January 17, 2023

Hi @KJA 

Looks like you are nearly there! i think you are on the right track with your custom trigger I would suggest making the following changes. This code assumes that the customFields key always exists. 

 

return z.request(options)
  .then((response) => {
    response.throwForStatus();
    const results = response.json; //these are the results of the api call

    const jobs = data.filter(item => {
  item.custom_fields = item.customFields.reduce((a, v) => ({ ...a, [v.name]: v.value}), {}); //this line turns the custom field array into an object. Always nice to give Zapier end users mappable fields over arrays. This outputs the custom field name and value. 
  if (item.custom_fields["Auto-Sync Status"]) {
  //assuming this is the custom field you want to search
    if (item.custom_fields["Auto-Sync Status"] == bundle.inputData.value) {
      //assume you will add a user input field with a key 'value'. or you could hardcode the right side
      return true
    }
  }
  return false
})

    return jobs;
  });

 

Liz_Roberts
1 person likes this
  • Liz_Roberts
    Liz_Roberts
K
  • KJABeginner
  • Author
  • Beginner
  • 2 replies
  • January 27, 2023
GetUWired wrote:

Hi @KJA 

Looks like you are nearly there! i think you are on the right track with your custom trigger I would suggest making the following changes. This code assumes that the customFields key always exists. 

 

 

Thanks for this! I haven’t had a chance to go back to the app to test properly, but I was initially getting syntax errors inside Zapier code view on the “item.custom_fields = item.customFields.reduce((a, v) => ({ ...a, [v.name]: v.value}), {});” line 

Terms & Conditions