API

Question

HI,&nbsp;Can I use any API in a URL, which can hold the data of the whole table and use it for the 3rd party application?The main agenda is to push the table data into the SQL server by using API, whenever data in QB is Inserted/Updated.

quickbasecoachd · Answer

You can use webhooks to detect an add, edit or delete and send any API call to your server.  Is that what you a4e trying to do?

vivekvishwanat2 · Answer

I need an API call to Load the whole data from the QB table into SQL server. :(

chayceduncan2 · Answer

You can work an API_DoQuery call - and specify something generic like:

?a=API_DoQuery&query={'3'.XEX.''}&clist=a

query={'3'.XEX.''} will grab all records where record ID is blank (which is impossible in QB) - and the clist=a will grab all fields - which in essence will get you the entire table.

Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

quickbasecoachd · Answer

I believe the API call would be API_DoQuery  There is help text available for the syntax

chayceduncan2 · Answer

Meant to say&nbsp;query={'3'.XEX.''} will grab all records where record ID is not blank - so it will grab everything in the table Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | chayceduncan@quandarycg.com Quandary Knowledge Base

Forum Discussion

API

Related Content

API Button Help

Restful API Report digesting JSON

Pipeline API Post

Nesting URL API Calls in one Button

Quickbase api in pipeline