HI, 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, when...
Forum Discussion
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
?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
Meant to say 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
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base