Help with inserting DB records based off API JSON retun

So I have some data being returning by a Google function via API. I’m just having a bit of trouble finding a way to get the repeat right or the schema right or something right in order of adding a DB insert step to write the returned data into the DB.

It could be that the way that google returns the data might not work well with Wappler but I’d love some help while I continue to try and figure this out.

The returned data is in a STRUCT format:

"rows [ ] " : “object (Struct` format)”

An object with as many results as can be contained within the maximum permitted reply size.

Which they further explain as:

image827×233 15.2 KB

And the data itself looks a bit like this in the returned API:

"rows": [
          {
            "f": [
              {
                "v": "-9.747449814584897"
              },
              {
                "v": "2021-04-03"
              },
              {
                "v": "2021"
              },
              {
                "v": "Apr"
              },
              {
                "v": "bin_1"
              },
              {
                "v": "Sat"
              }
            ]
          },

I’ve put the repeat in server connect on the Rows array based on the schema, but that only outputs each f, which contains an array of vvalues. Its these v values that I need to write into the DB.

Anyone have any thoughts or things to look into?