Forum Discussion

benrizz17's avatar
benrizz17
Qrew Member
12 days ago

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!

  • Yes you can parse the JSON and then write those pieces to a particular field.  It gets complicated as it all needs to happen in a big Jinja expression.  I have managed to do a very simple parse.   Here is the post I did on it

     

    https://community.quickbase.com/discussions/quickbase-discussions/parse-json/86845