Discussions

 View Only
  • 1.  API

    Posted 07-08-2019 11:06
    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.



  • 2.  RE: API

    Posted 07-08-2019 11:29
    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?


  • 3.  RE: API

    Posted 07-08-2019 11:31
    I need an API call to Load the whole data from the QB table into SQL server. :(


  • 4.  RE: API

    Posted 07-08-2019 11:37
    I believe the API call would be API_DoQuery

    There is help text available for the syntax


  • 5.  RE: API

    Posted 07-08-2019 11:37
    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


  • 6.  RE: API

    Posted 07-08-2019 12:52
    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