Question

Parse JSON data coming from PULL

  • 13 August 2022
  • 2 replies
  • 35 views

 

I’m getting the following data from an API

[
[
{
"keyword_data": {
"id": 657125,
"name": "abarth 124 spider review"
},
"positions": {
"2022-08-11": 3
},
"positions_mobile": {
"2022-08-11": 4
}
},
{
"keyword_data": {
"id": 657126,
"name": "abarth 124 spider price"
},
"positions": {
"2022-08-11": 5
},
"positions_mobile": {
"2022-08-11": 7
}
}
]
]

 

and I was wondering if there’s a way to turn this into a google sheet with columns like

keyowrd_data positions date positions_mobile date  
abarth 124 spider review 3 2022-08-11 4 2022-08-11  
   

 

     

 

I’ve been trying to parse the data through the CODE step but I’m not being able to get the correct code.
I was wondering if this is something you could help me with?

 

Thanks

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 6
Badge +6

Hey @agarbre ,

 

Yes this is possible. You can write a Javascript code for this.

Thanks @jayeshkumarbhatia for answering.
That’s what I’m not being able to do right now.

Tried different scripts but can’t make it work.