--- title: "Combine keys with values adapter in Connector builder | Supermetrics" slug: "combine-keys-with-values" description: "Use the \"combine keys with values\" adapter to pair a separate headers array with row values so that each row becomes keyed by header name." updated: 2026-06-04T07:44:18Z published: 2026-06-04T07:44:18Z canonical: "docs.supermetrics.com/combine-keys-with-values" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Combine keys with values Some APIs split the column names and the row values into separate arrays — for example, a top-level `headers` array and a `rows` array where each row only has a `values` array. `combine_keys_with_values` pairs them up by position so each row becomes an object keyed by the header names. | Field | Type | Required | Description | | --- | --- | --- | --- | | `keysPath` | string | Yes | JSONPath to the array of header names. | | `valuesPath` | string | Yes | JSONPath to the row value arrays, one per row. | | `dataDestinationPath` | string | Yes | JSONPath where the resulting rows are written. | Below you can find a before/after example: ``` { "headers": [ "date", "metric.impressionCount" ], "rows": [ { "values": [ "2020-01-01", "645" ] }, { "values": [ "2020-01-02", "921" ] } ] } ``` After the adapter runs, the row arrays are replaced with header-keyed objects: ``` { "headers": [ "date", "metric.impressionCount" ], "rows": [ { "date": "2020-01-01", "metric.impressionCount": "645" }, { "date": "2020-01-02", "metric.impressionCount": "921" } ] } ``` Configuration: ``` "response": { "dataRows": { "source": "jsonPath", "value": "$.rows.*" }, "dataAdapters": { "items": [ { "type": "combine_keys_with_values", "config": { "keysPath": "$.headers.*", "valuesPath": "$.rows.*.values", "dataDestinationPath": "$.rows" } } ] } } ``` Below you can find example field definitions that read from the transformed structure: ``` [ { "id": "date", "label": "Date", "dataType": "string.time.date", "value": { "source": "jsonPath", "value": "$.date" } }, { "id": "impression_count", "label": "Impression count", "dataType": "int.number.value", "value": { "source": "jsonPath", "value": "$['metric.impressionCount']" } } ] ```