Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
API
Vivek Vishwanath
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 ...
QuickBaseCoach Dev./Training
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 ...
Vivek Vishwanath
07-08-2019 11:31
I need an API call to Load the whole data from the QB table into SQL server. :(
QuickBaseCoach Dev./Training
07-08-2019 11:37
I believe the API call would be API_DoQuery There is help text available for the syntax
Chayce Duncan
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 ...
Chayce Duncan
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 ...
1.
API
1
Like
Vivek Vishwanath
Posted 07-08-2019 11:06
Reply
Reply Privately
Options Dropdown
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
0
Like
QuickBaseCoach Dev./Training
Posted 07-08-2019 11:29
Reply
Reply Privately
Options Dropdown
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
0
Like
Vivek Vishwanath
Posted 07-08-2019 11:31
Reply
Reply Privately
Options Dropdown
I need an API call to Load the whole data from the QB table into SQL server. :(
4.
RE: API
0
Like
QuickBaseCoach Dev./Training
Posted 07-08-2019 11:37
Reply
Reply Privately
Options Dropdown
I believe the API call would be API_DoQuery
There is help text available for the syntax
5.
RE: API
0
Like
Chayce Duncan
Posted 07-08-2019 11:37
Reply
Reply Privately
Options Dropdown
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
0
Like
Chayce Duncan
Posted 07-08-2019 12:52
Reply
Reply Privately
Options Dropdown
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
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic