Example of Message body for API_DoQuery Webhook
Can someone provide an example "Message Body" for an API_DoQuery Webhook, I'm lost on how the fields get populated from the XML reply and I'd like to see the structure of the code.
Forum Discussion
A SQL Update Query would be similar to what I was mentioning with Ruby or Node to run a background job for you. Partners like myself can help in that setting - thats also where a tool like Workato can be set to operate the way you first described the original intent.
You mentioned IOL - which is another option I forgot about. It will likely work pretty well for you - the only potential gap is that IOL would run when someone loads the form - so there is a lag between when the order is entered and when someone opens it and your script ones.
It sounds like you're pretty proficient in JS - so an option outside of a server process would be google scripts. You can code it in JS and set it to run on a schedule - so every 10 minutes, hour or so have it look for any new orders without an assigned contact, loop through each, query for a match, edit your orders
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
You mentioned IOL - which is another option I forgot about. It will likely work pretty well for you - the only potential gap is that IOL would run when someone loads the form - so there is a lag between when the order is entered and when someone opens it and your script ones.
It sounds like you're pretty proficient in JS - so an option outside of a server process would be google scripts. You can code it in JS and set it to run on a schedule - so every 10 minutes, hour or so have it look for any new orders without an assigned contact, loop through each, query for a match, edit your orders
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base