Webhook Pipeline Question
I am working with webhooks in a pipeline to obtain parts info from Upkeep (a CMMS software). So far, I have a pipeline that receives parts info from a specific location into a JSON format. I used a Webhook step in the pipeline with an HTTP Digest request, URL Encoded content type and was able to get the parts I need without an issue. So far, I can use that JSON info (I can call it with "a.json.results" to reference the whole array, or "a.json.results[0,1,etc].'attribute (part #, name, etc)' " to call out a specific attribute from one of the returned parts (objects).
My question is if there is a way to take the array of JSON results and parse that out into separate records in a QuickBase table? As in take the 100 or so parts that are returned, and create 100 records with the corresponding part #, name, etc. I attempted using the "Fetch JSON" step to then use an "Iterate Over JSON Records", but for some reason could not get that Fetch JSON to return any useful results like I have been with the Webhook call.
Any help would be greatly appreciated. Thank you!