IMPORTJSONAPI
IMPORTJSONAPI copied to clipboard
qeet
Use JSONPath to selectively extract data from any JSON or GraphQL API directly into Google Sheets.
Sorry i'm not sure how to message people on here. This is not an issue but I was wondering if you could help answer a question. I found your IMPORTJSONAPI...
When trying to import a json file that is very long I get an "ERROR: Unexpected end of JSON input". When I make the JSON file smaller (same formatting), then...
Is there a way to split data into multiple rows. I see that the column function can print to the line adjacent can this be standardized in some manner? Currently...
Hi I'm not allowed to use the google sheets tools at work for confidentiality reasons. Is there a way to integrate this script in Excel? Or is there i similar...
1. First, your code is amazing! Thanks for sharing it with us. 1. Second, **does someone have problem to debug the script when using this code?** With it in place...
I wonder if it's possible to have this one support the use of arrayformula, I believe a similar issue was opened previously that ended up using {;} to put all...
Is there a way to stagger requests correctly? For example I have 140 total requests in my google sheet and I want to only do 14 requests/s Would something like...
An API I want to connect to requires the following fields: X-Time: (current UTC timestamp in ms, if timestamp is more than five minutes apart from server's time, the request...
1. how can i retrieve the value of url from this query: =IMPORTJSONAPI("https://www.balai.cv/wp-json/wp/v2/posts", "$..*", "id,date_gmt,title.rendered,excerpt.rendered,categories,tags,link,yoast_head_json.og_image.url") using this query $..yoast_head_json.og_image..url in the [browser demo](https://jsonpath-plus.github.io/JSONPath/demo/) i get the desired results . i...
i have this formula `=IMPORTJSONAPI("https://api.firetype.ru/getFakeSellers.php";"$[*]";"user_id,nickname,vk,clan")` the fourth column is json object and the third is number... i want something like `=IMPORTJSONAPI("https://api.firetype.ru/getFakeSellers.php";"$[*]";"user_id,nickname,'https://vk.com/id'+vk,'['+clan.tag+'] '+clan.name")` so clan name and tag will be in...
