Forum Discussion
HASSANNAZEER
8 years agoFrequent Visitor
Api token
Can anyone help me with connecting this data source using API KEY http://developer.fulcrumapp.com
HASSANNAZEER
8 years agoFrequent Visitor
When I Try Query API, It does not work.
Formatting Calls to the Query API
All Query API requests should follow this general pattern:
https://api.fulcrumapp.com/api/v2/query?token={API Token}&q={SQL Statement}If you encounter errors, double-check that you are using the correct API token, and that your SQL statement is valid. A common use case example is to get a count of the records in a form, grouped by status:
Example
https://api.fulcrumapp.com/api/v2/query/?token=abc-123&q=SELECT _status, COUNT(*) FROM "Park Inventory" GROUP BY _status ORDER BY COUNT(*) DESCResult
_status,count
City,19
Private,5
Local,3
County,3
State,1Anonymous
8 years agoNot applicable
HASSANNAZEER,
What error message do you get in Power BI Desktop?
Regards,
Lydia