Forum Discussion
_anomDiebolt_
9 years agoQrew Elite
Use script instead of webhooks to overcome the 10 web hook per table limitation.
In my opinion QuickBase has made a mistake forcing you to embed tokens and values within the XML body of a webhook directed at the QuickBase endpoint. All of QuickBase's APIs can be called without an XML body using either a GET or POST by packing the parameters into a query string format instead of an XML body. Using an XML body just makes the webhook definition difficult to read and error prone.
Used in this context the webhook interface should just solicit the parameters involved:
act: xxxxxx
records_csv: xxxxxx
clist: xxxxxx
and allow the backend to format the request from the entered information.
This same abstraction of just dealing with the parameters allows you to call API methods with jQuery (or some other library) without involving any XML:
$.post(dbidTable, {
act: "API_ImportFromCSV",
records_csv: csv_data,
clist: "6.7.8.9.10.11.12.13.14"
});
There are simply four parameters {dbid, act, records_csv, clist} to specify in the above call to API_ImportFromCSV. and a lot less line noise.
ASK: Please Give Me Your Formulas
https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784
In my opinion QuickBase has made a mistake forcing you to embed tokens and values within the XML body of a webhook directed at the QuickBase endpoint. All of QuickBase's APIs can be called without an XML body using either a GET or POST by packing the parameters into a query string format instead of an XML body. Using an XML body just makes the webhook definition difficult to read and error prone.
Used in this context the webhook interface should just solicit the parameters involved:
act: xxxxxx
records_csv: xxxxxx
clist: xxxxxx
and allow the backend to format the request from the entered information.
This same abstraction of just dealing with the parameters allows you to call API methods with jQuery (or some other library) without involving any XML:
$.post(dbidTable, {
act: "API_ImportFromCSV",
records_csv: csv_data,
clist: "6.7.8.9.10.11.12.13.14"
});
There are simply four parameters {dbid, act, records_csv, clist} to specify in the above call to API_ImportFromCSV. and a lot less line noise.
ASK: Please Give Me Your Formulas
https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784
RyanParr
9 years agoQrew Assistant Captain
This is probably a stupid question but.. where would i put the script? In a formula URL field?