Share
Report
1I created a custom connector to gather data from the Google Search Console API. I was able to get results back and use the Apply to each to add data to a table I created in dataverse for most of the data. I'm having trouble with the structure of one of the fields. The keys field (see below) is actually a collection/array of 2 fields.
{
"keys": [
“Keyword 1"
],
"clicks": 635,
"impressions": 8142,
"ctr": 0.0779906656841071,
"position": 4.996069761729305
},
{
"keys": [
“Keyword 2”
],
"clicks": 564,
"impressions": 11221,
"ctr": 0.05026289991979324,
"position": 13.727118795116299
}
]
I'm easily able to use Apply to Each and then create a row with the clicks / impressions / ctr / position but I'd also like to save the domain and keyword (the 2 elements in the keys).
I tried to use the first/last expression but flow doesn't seem to let me use it for data that is returned from a custom connector. Any suggestions?
All responses (
Answers (
