500 Error while attempting to extract widget data via JAQL
I'm attempting to pull the data from a few widgets we have in dashboards into a CSV to import this data into another tool we have in our tech stack. Everything from the process to get a widget's values from the elasticube here is working, except for the step where the cURL and URL request are generated.
I've used the ID from the JAQL output of step a, as well as the JAQL statement (with all formulas starred) in my request on the API Reference Page's v0.9 section, but I get the following 500 error in response:
{ "error": true, "message": "read ECONNRESET" }
What is needed to get the correct 200 response from this call so I'm able to get the data via API pull?
-
Hi Ben, could you post the full cURL command you ended up with, that results in this error?
Additionally, I highly recommend getting familiar with the JAQL syntax, via these articles:
https://developer.sisense.com/display/API2/JAQL
And trying to execute the raw JAQL query in the "JAQL Runner" tool first. If it doesn't work. there's an issue in the JAQL query syntax, may be with the data source field or something else within.
If JAQL runner does work but the same query fails with cURL then the format of the cURL command may be the issue - for example missing the correct authentication token in the headers - in that case, I would use a tool such as Postman to generate the HTTP request using the JAQL as a payload, and using Postman to generate the appropriate cURL command once you got it to work
Please sign in to leave a comment.
Comments
1 comment