Skip to main content
POST
/
api
/
v1
/
gdrive
/
upload-gsheet
cURL
curl --request POST \
  --url http://api/v1/gdrive/upload-gsheet \
  --header 'Content-Type: application/json' \
  --data '
{
  "pivotConfig": {
    "rowTotals": true,
    "columnTotals": true,
    "hiddenMetricFieldIds": [
      "<string>"
    ],
    "columnOrder": [
      "<string>"
    ],
    "metricsAsRows": true,
    "pivotDimensions": [
      "<string>"
    ]
  },
  "hiddenFields": [
    "<string>"
  ],
  "customLabels": {},
  "columnOrder": [
    "<string>"
  ],
  "showTableNames": true,
  "metricQuery": {
    "metadata": {
      "hasADateDimension": {
        "name": "<string>",
        "label": "<string>",
        "table": "<string>"
      }
    },
    "customDimensions": [
      {
        "id": "<string>",
        "name": "<string>",
        "table": "<string>",
        "type": "bin",
        "dimensionId": "<string>",
        "binType": "fixed_number",
        "binNumber": 123,
        "binWidth": 123,
        "customRange": [
          {
            "to": 123,
            "from": 123
          }
        ]
      }
    ],
    "additionalMetrics": [
      {
        "label": "<string>",
        "type": "percentile",
        "description": "<string>",
        "sql": "<string>",
        "hidden": true,
        "round": 123,
        "compact": "thousands",
        "format": "km",
        "table": "<string>",
        "name": "<string>",
        "index": 123,
        "filters": [
          {
            "values": [
              "<any>"
            ],
            "operator": "isNull",
            "id": "<string>",
            "target": {
              "fieldRef": "<string>"
            },
            "settings": "<any>",
            "disabled": true,
            "required": true
          }
        ],
        "baseDimensionName": "<string>",
        "uuid": "<string>",
        "percentile": 123,
        "formatOptions": {
          "type": "default",
          "round": 123,
          "separator": "default",
          "currency": "<string>",
          "compact": "thousands",
          "prefix": "<string>",
          "suffix": "<string>",
          "timeInterval": "RAW",
          "custom": "<string>"
        }
      }
    ],
    "tableCalculations": [
      {
        "type": "number",
        "format": {
          "type": "default",
          "round": 123,
          "separator": "default",
          "currency": "<string>",
          "compact": "thousands",
          "prefix": "<string>",
          "suffix": "<string>",
          "timeInterval": "RAW",
          "custom": "<string>"
        },
        "sql": "<string>",
        "displayName": "<string>",
        "name": "<string>",
        "index": 123
      }
    ],
    "limit": 123,
    "sorts": [
      {
        "nullsFirst": true,
        "descending": true,
        "fieldId": "<string>"
      }
    ],
    "filters": {
      "tableCalculations": {
        "or": [
          "<any>"
        ],
        "id": "<string>"
      },
      "metrics": {
        "or": [
          "<any>"
        ],
        "id": "<string>"
      },
      "dimensions": {
        "or": [
          "<any>"
        ],
        "id": "<string>"
      }
    },
    "metrics": [
      "<string>"
    ],
    "dimensions": [
      "<string>"
    ],
    "exploreName": "<string>"
  },
  "exploreId": "<string>",
  "projectUuid": "<string>"
}
'
{
  "results": {
    "jobId": "<string>"
  },
  "status": "ok"
}

Body

application/json
​
columnOrder
string[]
required
​
showTableNames
boolean
required
​
metricQuery
object
required
​
exploreId
string
required
​
projectUuid
string
required
​
pivotConfig
object
​
hiddenFields
string[]
​
customLabels
object

Response

Success

​
results
object
required
​
status
enum<string>
required
Available options:
ok