D
D
Dmitry Zhvakin2019-02-17 20:00:03
JSON
Dmitry Zhvakin, 2019-02-17 20:00:03

How to send JSON request via POST method from Google Sheet using ImportJSON script?

Good afternoon!
There is a third-party script https://github.com/bradjasper/ImportJSON that allows you to send a Json request to a site from a Gsheets cell as a formula and receive a response in the same cell.
Understanding, please tell me how to write a formula for this script in order to get a response from the site in cell A2?
Sheet:
https://docs.google.com/spreadsheets/d/1-7E7mhuP-V...
Request itself:
headers:
x-auth-token: k2sjQKT8RbNrTGZTo4ZDccxB
content-type: application/json
Body
{"data":{ "type":"link","attributes":{"short_url":"Example","web_url":" https://lenta.ru ","pixel_ids":

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question