HydraCore
API by router

Google sheets

List Spreadsheets

GET
/internal/v1/instances/{instance_id}/sheets/list

Path Parameters

instance_idInstance Id
Formatuuid

Query Parameters

connection_name?Connection Name
query?Query

Search query for spreadsheet name

max_results?Max Results
Default20
Range1 <= value <= 100

Response Body

curl -X GET "https://loading/internal/v1/instances/497f6eca-6276-4993-bfeb-53cbbbba6f08/sheets/list?connection_name=string&query=string&max_results=20"
null
{
  "detail": [
    {
      "loc": [
        "string"
      ],
      "msg": "string",
      "type": "string"
    }
  ]
}

Read Sheet Range

GET
/internal/v1/instances/{instance_id}/sheets/read

Path Parameters

instance_idInstance Id
Formatuuid

Query Parameters

spreadsheet_idSpreadsheet Id
range?Range
Default"Sheet1"
connection_name?Connection Name

Response Body

curl -X GET "https://loading/internal/v1/instances/497f6eca-6276-4993-bfeb-53cbbbba6f08/sheets/read?spreadsheet_id=string&range=Sheet1&connection_name=string"
null
{
  "detail": [
    {
      "loc": [
        "string"
      ],
      "msg": "string",
      "type": "string"
    }
  ]
}