Skip to main content
Question

API

  • July 8, 2019
  • 0 replies
  • 24 views
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, whenever data in QB is Inserted/Updated.

    This topic has been closed for replies.

    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?
    I need an API call to Load the whole data from the QB table into SQL server. :(
    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
    I believe the API call would be API_DoQuery

    There is help text available for the syntax
    Terms & ConditionsAccessibility statement