Forum Discussion
HI,
Thanks it helped me as well. i got a quick question.
I have added some javascript to the HTML files i need to build the pipeline such that it reads the spreadsheet and returns the data within( this bit has been done) For my next step i want something that if i update data in spreadsheet it should reflect changes on HTML file?
if you can help me that would be great.
Please find attached Demo Display Board.zip (7.3 KB)
Thanks
- debra_paponette5 years agoNew Contributor
To this date nope. i have tried everything from create an SSL rest account and I am still getting the issue. The API works in postman and the browser but not the rest snap. I am out of ideas at this point
- Garrett5 years agoNew Contributor II
I was told to try something like this and it is working.
My rest API requires a query parameter.
http://ServiceURL?query=select * from table where id=1234
I had put in the URL into the Service URL box and then added a query parameter called query.
That did not work.
What does work is this:
‘https://ServiceURL /services/?query=’ + encodeURIComponent(‘select * from incidents where id < 1000’)
And that entire line went into the ServiceURL.
Seems that they do not fix the encoding in the query parameters.
- ptaylor5 years agoEmployee
Set the Service URL to “https://ServiceURL/services” and use the “Query parameters” table to set the query parameters. See the docs for this snap.