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.

Hi friends, looking for help with this. I need to do a call into our CRM and then format the json output so I can use each line of information in a further Zapier step, specifically sending it into a template in Formstack Documents.

Here’s the redacted API call code generated by Postman:

var myHeaders = new Headers();
myHeaders.append("X-API-Key", "xxx");
myHeaders.append("X-Camp-Initials", "XXX");
myHeaders.append("Content-Type", "application/json");

var requestOptions = {
  method: 'GET',
  headers: myHeaders,
  redirect: 'follow'
};

fetch("https://APIURL/variable_from_earlier_zap_step", requestOptions)
  .then(response => response.text())
  .then(result => console.log(result))
  .catch(error => console.log('error', error));

and here’s some sample output from the CRM

p
    {
        "medicationId": "nnn",
        "section": "campers",
        "personId": "nnn",
        "year": "2021",
        "name": "Med 01",
        "dosage": "Dose 01",
        "reasonForTaking": "Reason 01",
        "howGiven": "How 01",
        "startDate": "2021-04-25",
        "endDate": "2021-04-30",
        "critical": "false",
        "deliveries":  
            "Breakfast",
            "Snack",
            "Bedtime"
        ]
    },
    {
        "medicationId": "nnn",
        "section": "campers",
        "personId": "nnn",
        "year": "2021",
        "name": "Med 02",
        "dosage": "Dose 02",
        "reasonForTaking": "Reason 02",
        "howGiven": "How 02",
        "startDate": "2021-04-25",
        "endDate": "2021-04-30",
        "critical": "false",
        "deliveries": r
            "Bedtime"
        ]
    }
]

There can be up to 16 results from each call (that’s hard coded in and not a problem in this case).

Basically I just need to be able to map Name, dosage, reason, howgiven and deliveries to mappable fields on the Formstack side. Note that the first array of results will be group 1, then the next group 2, etc up to 16. The order that the results appear does NOT matter.

Here’s an example of what Formstack document is expecting:

Thanks so much in advance for the help! I tried to do this with Zapier’s built in web hooks and formatting features but I can’t because it will only return the first array during the testing phase.

@pshifrin 

Can you send a screenshot of what is being returned? 

I would guess that since the custom hook returns an array of objects, Zapier is setting up for a loop (the code step behaves this way). You only see the first response because Zapier would process each object returned individually.  https://zapier.com/help/create/code-webhooks/use-javascript-code-in-zaps



I would suggest making the request in a code block using fetch as opposed to Zapier’s webhook. 

That way you can force your results to return an object.

 

const request = await fetch("https://APIURL/variable_from_earlier_zap_step", {
  method: "GET",
  headers: {
  "X-API-Key": "xxx",
  "X-Camp-Initials": "XXX",
  "Content-Type", "application/json"
  },
});
  data = await request.json();


return {data}

 

Reply


Terms & Conditions