Forum Discussion
MichaelTamoush
Qrew Captain
How did you integrate with Ajera? I'd rather do it natively but figured it would need to be in Pipelines list of associated programs.
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------
ChristopherWhe1
3 years agoQrew Member
I used a combination of Webhook steps and JSON Handler steps. At a high level, it looks like this:
Open session (Webhook - Make Request)
Parse response to get Session Token (Text - Apply Regular Expression)
Get JSON (JSON Handler - Fetch JSON)
Iterate over JSON payload (JSON Handler - Iterate over JSON records)
For each JSON Object
Search for matching QB records (Quickbase - Search Records)
For each QB Record, there should only be one
Update QB records (Quickbase - Update Record)
Close session (Webhook - Make Request)
------------------------------
Chris Wheatley
------------------------------
Open session (Webhook - Make Request)
Parse response to get Session Token (Text - Apply Regular Expression)
Get JSON (JSON Handler - Fetch JSON)
Iterate over JSON payload (JSON Handler - Iterate over JSON records)
For each JSON Object
Search for matching QB records (Quickbase - Search Records)
For each QB Record, there should only be one
Update QB records (Quickbase - Update Record)
Close session (Webhook - Make Request)
------------------------------
Chris Wheatley
------------------------------