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
Thank you for the thought put into this.
Option one is risky as this database has been in production for over a year so I'm reluctant to change the primary key.
Option two, I've arranged a demo with Workato.
Option three, I'm writing some Java for a button, but what we want to avoid is any manual intervention which is why we're not looking to use QB relationships as they need someone to click something.
I'm using the iol technique and API_DoQuery for the Java script but I'll look into Ruby or Node.
Option four, we have a webhook to our front end system, the orders come through to us when the client hits submit. I'd want to keep clear of touching anything here as it all works.
One thing I'm surprised about Quickbase is that it is so difficult to update one table from another by using a common field which isn't a relationship, it's baffling, any chance you can ask someone to write the equivalent of an SQL UPDATE query or Excel Vlookup?
Jack Fretwell
jfretwell@mailandprint.co.uk
Option one is risky as this database has been in production for over a year so I'm reluctant to change the primary key.
Option two, I've arranged a demo with Workato.
Option three, I'm writing some Java for a button, but what we want to avoid is any manual intervention which is why we're not looking to use QB relationships as they need someone to click something.
I'm using the iol technique and API_DoQuery for the Java script but I'll look into Ruby or Node.
Option four, we have a webhook to our front end system, the orders come through to us when the client hits submit. I'd want to keep clear of touching anything here as it all works.
One thing I'm surprised about Quickbase is that it is so difficult to update one table from another by using a common field which isn't a relationship, it's baffling, any chance you can ask someone to write the equivalent of an SQL UPDATE query or Excel Vlookup?
Jack Fretwell
jfretwell@mailandprint.co.uk