Introduction

Welcome to Gridly API document. You can use our API endpoints to access your data in Gridly

Gridly API is organized around REST, accepts raw-data request bodies, returns standard HTTP response codes, authentication, and verbs.

We have language bindings in Curl, you can view code examples in the area to the right.

Authentication

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/{VIEW_ID}/records' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

Gridly API uses API key to authenticate requests. All API requests must be made over HTTPS and authenticated by having the API key included in the HTTP request header that looks like the following:

Authorization: ApiKey {YOUR_API_KEY}

To quickly get your API key, access your Gridly Dashboard, then select a Grid View and you can find the key in API quick start right panel.

Note: Owner and Administrators can go to Settings/API keys to create company-level API keys with scoped privileges and accesses.

Make sure to replace {YOUR_API_KEY} and {VIEW_ID} with yours.

Errors

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/xpzyv44ym2v49f' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
    "timestamp": "2021-05-31T14:25:13.293065+07:00",
    "status": 404,
    "code": "viewIsNotFound",
    "message": "View \"xpzyv44ym2v49f\" could not be found.",
    "path": "/v1/views/xpzyv44ym2v49f/records"
}

Gridly API uses conventional HTTP response codes to indicate the success or failure of a request.

In general: Codes in the 2xx range indicate success. Codes in the 4xx range indicate user errors that failed given the information provided. Codes in the 5xx range indicate errors from Gridly’s servers.

An error response will return a JSON body that contains code and message fields. Those will provide specific error conditions and human-readable message to identify what caused the error.

The following table explains the REST error response elements.

Http statuses

Gridly error codes

Changelog

2023-05-18

Api for path

Project

Project resource

Project resource representation

{ "id": string, "name": string, "description": string }

This table explains each property in the project resource.

List projects

CODE

curl --location --request GET 'https://api.gridly.com/v1/projects' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
  {
    "id": 42,
    "name": "Foodie",
    "description": "I love food"
  }
]

To list projects of a company.

HTTP Request

GET /v1/projects

Response

Return a list of projects in an array if succeeded. Otherwise, return an error.

Retrieve a project

CODE

curl --location --request GET 'https://api.gridly.com/v1/projects/42' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
  "id": 42,
  "name": "Foodie",
  "description": "I love food"
}

To retrieve a project.

HTTP Request

GET /v1/projects/<id>

ID can be found in the URL of the web application: app.gridly.com/projects/<id>.

Response

Return project data in object if succeeded. Otherwise, return an error.

Database

Database resource

Database resource representation

{ "id": string, "name": string }

This table explains each property in the database resource.

List databases

CODE

curl --location --request GET 'https://api.gridly.com/v1/databases?projectId=42' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
  {
    "id": "me8y2x4v5v3djy",
    "name": "Cuisine"
  }
]

To list databases of a project.

HTTP Request

GET /v1/databases

Parameter

projectId optional

ID of the project. The ID can be found in the URL of the web application: app.gridly.com/projects/<id>.

Response

Return a list of databases in an array if succeeded. Otherwise, return an error.

Retrieve a database

CODE

curl --location --request GET 'https://api.gridly.com/v1/databases/me8y2x4v5v3djy' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
  "id": "me8y2x4v5v3djy",
  "name": "Cuisine"
}

To retrieve a database.

HTTP Request

GET /v1/databases/<id>

Response

Return database data in an object if succeeded. Otherwise, return an error.

Grid

Grid resource

Grids are like sheets or a table within a database.

Grid resource representation

{ "id": string, "name": string, "columns": [ { "id": string, "name": string, "type": string, "languageCode": string, "isSource": boolean, "isTarget": boolean, "dependsOn": string, "reference": { "grid": { "name": string }, "column": { "name": string, "type": string } } } ] }

This table explains each property in the grid resource.

List grids

CODE

curl --location --request GET 'https://api.gridly.com/v1/grids?dbId=3xep36emk4j1dq' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
  {
    "id": "v182ye104j8o33",
    "name": "Pizza"
  },
  {
    "id": "me6q2mvj4868l8",
    "name": "Burger"
  }
]

To list grids of a database.

GET /v1/grids

Parameters

dbId required

ID of the database you want to list of all the grids.

Response

Return a list of grids from a database if succeeded. Otherwise, return an error.

Retrieve a grid

CODE

curl --location --request GET 'https://api.gridly.com/v1/grids/em8vw50wzkl111' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
  "id": "em8vw50wzkl111",
  "name": "Food",
  "columns": [
    {
      "id": "ingredient",
      "name": "Ingredient",
      "type": "multipleLines"
    },
    {
      "id": "price",
      "name": "Price",
      "type": "number"
    }
  ]
}

To retrieve a grid.

HTTP Request

GET /v1/grids/<id>

Response

Return grid data in an object if succeeded. Otherwise, return an error.

Create grid

CODE

curl --location --request POST 'https://api.gridly.com/v1/grids?dbId=xk0d5xz8j4xj6v' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'' \
--header 'Content-type: application/json' \
--data-raw '{
   "name": "Food",
   "metadata": {
           "city": "Helsingborg",
           "cost": "42"
   }
}

OUTPUT

{
  "id": "410nzk2op1zedp",
  "defaultAccessViewId": "me35v9mqd0e93y",
  "name": "Food",
  "metadata": {
     "city": "Helsingborg",
     "cost": "42"
   }
}

To create a grid.

POST /v1/grids

Path parameters

Request body

You can find templateGridId of each template by going ty “Templates”, then select corresponding template.

Response

Return database data in an object if succeeded. Otherwise, return an error.

Update a grid

CODE

curl --location --request PATCH 'https://api.gridly.com/v1/grids/410nzk2op1zedp' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--header 'Content-type: application/json' \
--data-raw '{
   "name": "Fast Food",
   "metadata": {
           "type": "Burger",
           "cost": "42"
   }
}'

OUTPUT

{
  "id": "410nzk2op1zedp",
  "defaultAccessViewId": "me35v9mqd0e93y",
  "name": "Fast Food",
  "metadata": {
     "type": "Burger",
     "cost": "42"
   }
}

To update a grid from a database.

HTTP Request

PATCH /v1/grids/<id>

Request body

Response

Return grid ‘s name and metadata in an object if succeeded. Otherwise, return an error.

Delete a grid

CODE

curl --location --request DELETE 'https://api.gridly.com/v1/grids/410nzk2op1zedp' \
--header 'Authorization: ApiKey yourApiKey'

To delete a grid.

DELETE /v1/grids/<id>

Path parameters

View

View resource

CODE

curl --location --request POST 'https://api.gridly.com/v1/grids?dbId=xk0d5xz8j4xj6v

Views represent a way to display all data or a subset of data.

View resource representation

{ "id": string, "name": string, "columns": [ { "id": string, "name": string, "type": string, "languageCode": string, "isSource": boolean, "isTarget": boolean, "dependsOn": string, "reference": { "grid": { "name": string }, "column": { "name": string, "type": string } } } ], "records": [ <recordRepresentation>, ... ] }

This table explains each property in the view resource.

List views

CODE

curl --location --request GET 
'https://api.gridly.com/v1/views?gridId=v1jqdkj24j1nkz' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
  {
    "id": "41wk9m9q0w8mnn",
    "name": "Default View"
  },
  {
    "id": "emv2qozw1jn5vo",
    "name": "Default view"
  },
  {
    "id": "me2jk8me5225l8",
    "name": "Pizza"
  },
  {
    "id": "emv2qjxv3pjo11",
    "name": "Burger"
  }
]

To list views of a grid or branch.

HTTP Request

GET /v1/views

Parameters

gridId conditionally required.

ID of a grid. This is required if branchId is not specify

branchId conditionally required.

ID of a branch. This is required if gridId is not specify

Response

Return a list of view in an array if succeeded. Otherwise, return an error.

Retrieve a view

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
  "id": "v1v9jwwk1lwnkz",
  "name": "Food",
  "columns": [
    {
      "id": "ingredient",
      "name": "Ingredient",
      "type": "multipleLines"
    },
    {
      "id": "price",
      "name": "Price",
      "type": "number"
    }
  ]
}

To retrieve an existing view.

The API returns a view data in object, we can get all the columns of the view via columns field of this object.

HTTP Request

GET /v1/views/<id>

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Response

Return view data in an object if succeeded. Otherwise, return an error.

Make sure to replace {YOUR_API_KEY} and {VIEW_ID} with yours.

Import

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/import' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}' \
--form 'file=@"/Users/tri/Desktop/fastlane.csv"' \
--form 'importRequest="{ 
 "firstDataRow": 1,
 "columnMappings":[{
   "columnId": "column1",
   "fileColumnIndex": 1
   }]
  }"'

To import a file (.csv) into a view.

Import API use multipart request

HTTP Request

POST /v1/views/<id>/import

Request body

importRequest

{ "withHeader": true, "backup": true, "columnMappings": [ { "columnId": "column1", "fileColumnIndex": 0 } ] }

Response

Returns status 202 to indicate the server has accepted the file.

Export

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/export' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

To export data from a view into a file (.csv).

HTTP Request

GET /v1/views/<id>/export

Request parameters

Response

Return spreadsheet file (.csv) contains all columns and records of the View.

Merge a view

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/em8vw50wzkl111/merge?destinationViewId=xk0d5xz8j4xj6v&mergeRecordOptions=add,update,delete,override' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--header 'Content-type: application/json'

OUTPUT

{
  "id": "410nzk2op1zedp",
  "status": "running"
}

To merge a view of branch to other view of other branch

HTTP Request

POST /v1/views/<viewId>/merge

Request parameters

mergeRecordOptions

Response

Return asynchronous task of the request with id and status. To retrieve the latest status, check task api.

Column

Column resource

Column resource representation

{
  "id": string,
  "isSource": boolean,
  "isTarget": boolean,
  "name": string,
  "numberFormat": {
    "type: string,
    "decimalPlaces": number,
    "currencySymbol": string,
    "use1000Separator": boolean
  }
  "selectionOptions": [
  	 string, ...
  ]
  "reference": {
    "column": {
      "id": string,
      "name": string
    },
    "grid": {
      "id": string,
      "name": string
    },
    "type": string
  },
  "type": string
}

This table explains each property in the column resource.

Predefined columns

Predefined column representation

Predefined column IDs are denoted with _ . This table describes column Id for each column, which can be used on filtering and sorting record.

Retrieve a column

CODE

curl --location --request GET 'http://api.gridly.com/v1/views/ednq6m4m50pykl/columns/ingredient' \
--header 'Authorization: ApiKey yourApiKey'

OUTPUT

{
  "id": "ingredient",
  "isSource": false,
  "isTarget": false,
  "name": "Ingredient",
  "type": "singleLine"
}

To retrieve a column.

HTTP Request

GET /v1/views/<viewId>/columns/<id>

Path parameters

Create a column

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/ednq6m4m50pykl/columns' \
--header 'Authorization: ApiKey yourApiKey' \
--header 'Content-Type: application/json' \
--data-raw '{
    "name": "Ingredient",
    "type": "singleLine"
}'

OUTPUT

{
  "id": "column1",
  "isSource": false,
  "isTarget": false,
  "name": "Ingredient",
  "type": "singleLine"
}

To create a column.

POST /v1/views/<viewId>/columns

Path parameters

Request body

Required parameters

Column types include singleLine, multipleLines, richText , markdown, singleSelection, multipleSelections, boolean, number, datetime, files, reference, language, formula, json and yaml.

Optional parameters

Update a column

CODE

curl --location --request PATCH 'https://api.gridly.com/v1/views/mqnl0vej02l5l8/columns/recipe' \
--header 'Authorization: ApiKey yourApiKey' \
--header 'Content-Type: application/json' \
--data-raw '{
    "name": "Best-selling recipe"
    "languageCode": "frFR"
}'

OUTPUT

{
  "id": "recipe",
  "isSource": false,
  "isTarget": false,
  "languageCode": "frFR",
  "name": "Best-selling recipe",
  "type": "language"
}

To update a column.

PATCH /v1/views/<viewId>/columns/<id>

Path parameters

Request body

Optional parameters

Delete a column

CODE

curl --location --request DELETE 'https://api.gridly.com/v1/views/mqnl0vej02l5l8/columns/ingredient' \
--header 'Authorization: ApiKey yourApiKey'

To delete a column.

DELETE /v1/views/<viewId>/columns/<id>

Path parameters

Add a column to a view

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/mqnl0vej02l5l8/columns/ingredient/add' \
--header 'Authorization: ApiKey yourApiKey'

OUTPUT

{
  "id": "ingredient",
  "isSource": false,
  "isTarget": false,
  "name": "Ingredient",
  "type": "singleLine"
}

To add an existing grid column to a view.

POST /v1/views/<viewId>/columns/<id>/add

Path parameters

Remove a column from a view

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/mqnl0vej02l5l8/columns/ingredient/remove' \
--header 'Authorization: ApiKey yourApiKey'

To remove a column from a view.

POST /v1/views/<viewId>/columns/<id>/remove

Path parameters

Dependency

Dependency resource

Dependency resource representation

{
  "id": string,
  "sourceColumnId": string,
  "targetColumnId": string
}

This table explains each property in the dependency resource.

List dependencies

CODE

curl --location --request GET 'http://api.gridly.com/v1/views/ednq6m4m50pykl/dependencies' \
--header 'Authorization: ApiKey yourApiKey'

OUTPUT

[
  {
    "id": "mddn9jyedd43q6y",
    "sourceColumnId": "enUS",
    "targetColumnId": "viVN"
  },
  {
    "id": "ewwn4xv502y5ykl",
    "sourceColumnId": "enUS",
    "targetColumnId": "frFR"
  }
]

To list dependencies.

HTTP Request

GET /v1/views/<viewId>/dependencies

Path parameters

Retrieve a dependency

CODE

curl --location --request GET 'http://api.gridly.com/v1/views/ednq6m4m50pykl/dependencies/mddn9jyedd43q6y' \
--header 'Authorization: ApiKey yourApiKey'

OUTPUT

{
  "id": "mddn9jyedd43q6y",
  "sourceColumnId": "enUS",
  "targetColumnId": "viVN"
}

To retrieve a dependency.

HTTP Request

GET /v1/views/<viewId>/dependencies/<id>

Path parameters

Create a dependency

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/ednq6m4m50pykl/dependencies' \
--header 'Authorization: ApiKey yourApiKey' \
--header 'Content-Type: application/json' \
--data-raw '{
    "sourceColumnId": "enUS",
    "targetColumnId": "viVN"
}'

OUTPUT

{
  "id": "mddn9jyedd43q6y",
  "sourceColumnId": "enUS",
  "targetColumnId": "viVN"
}

To create a dependency.

POST /v1/views/<viewId>/dependencies

Path parameters

Request body

Required parameters

Update a dependency

CODE

curl --location --request PUT 'https://api.gridly.com/v1/views/mqnl0vej02l5l8/dependencies/mddn9jyedd43q6y' \
--header 'Authorization: ApiKey yourApiKey' \
--header 'Content-Type: application/json' \
--data-raw '{
    "sourceColumnId": "enUS",
    "targetColumnId": "frFR"
}'

OUTPUT

{
  "id": "mddn9jyedd43q6y",
  "sourceColumnId": "enUS",
  "targetColumnId": "frFR"
}

To update a dependency.

PUT /v1/views/<viewId>/dependencies/<id>

Path parameters

Request body

Optional parameters

Delete a dependency

CODE

curl --location --request DELETE 'http://api.gridly.com/v1/views/mqnl0vej02l5l8/dependencies/mddn9jyedd43q6y' \
--header 'Authorization: ApiKey yourApiKey'

To delete a dependency.

DELETE /v1/views/<viewId>/dependencies/<id>

Path parameters

Record

Pagination

CODE

# Use `page={"offset": 5, "limit": 10}` to get 10 records from the sixth  
curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/records?page=%7B%22offset%22%3A+5%2C+%22limit%22%3A+10%7D' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

The list API method uses a page object in the query parameter for the bulk fetching. By default, maximun 100 resources will be returned on each request, if this page object isn’t specified in the request, the first page of resources from 1 to 100 will be returned.

To get the full list of resources that more than 100 items, compares the field X-Total-Count in the response header of the first request, then calculate page param for the next requests.

Value of page has the following format { "offset": <offset>, "limit": <limit> }. Note that this value object need to be URL encoded.

offset

A number to indicate the starting index of the resource that we need to get. It is zero by default.

limit

A limit on the number of resources to be returned. Its default value is 100 and the max is 1000.

Filtering

CODE

# `query={"a3cb4a5dadf2e43ca9bafc437391a0dce": {"contains": "pizza" } }`
curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/records?query=%7B%22a3cb4a5dadf2e43ca9bafc437391a0dce%22%3A+%7B%22contains%22%3A+%22pizza%22+%7D+%7D' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

To filter on a API response, use query object in the query params of the HTTP request.

Value of query has the following format { "<columnId>": { "<operator>": <value> } }. Note that this value object need to be URL encoded.

columnId

The ID of the column to be filtered. To filter on predefined columns, details column ID here.

operator

Is one of the following values:

You can pass many key-value pairs of filters like this:

{ "ingredient": { "contains": "cheese" }, "price": { "<": 42 } }

Sorting

CODE

# `sort={"a3cb4a5dadf2e43ca9bafc437391a0dce": "desc"}`
curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/records?sort=%7B%22a3cb4a5dadf2e43ca9bafc437391a0dce%22%3A+%22desc%22%7D' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

To sort the response list, use the sort object in the query params.

Value of sort has the following format { "<columnId>": "<sortDirection>" }. Note that this value object need to be URL encoded.

columnId

The ID of the column to be sorted. To sort on predefined columns, details column ID here.

sortDirection

The direction to sort by. The value can be:

We can pass many key-value pairs like this:

{ "ingredient": "asc", "price": "desc" }

Record resource

Record resource representation

{ "id": string, "cells": [ { "columnId": string, "value": various, "dependencyStatus": string, "sourceStatus": string }, ... ], "path": string }

This table explains each property in the record resource.

“Various” means any type depending on the column. For example: string, number, datetime, etc.

List records

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/records?columnIds=a3cb4a5dadf2e43ca9bafc437391a0dce,a3cb4a5dadf2e43ca9bafc437391a0dce' \
  --header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
  {
    "id": "me6q2mvj4868l8",
    "cells": [
      {
        "columnId": "v182ye104j8o33",
        "value": "spaghetti"
      },
      {
        "columnId": "em8vw50wzkl111",
        "dependencyStatus": "upToDate",
        "sourceStatus": "readyForTranslation",
        "value": 99
      }
    ],
    "path": "Path Level 1"
  },
  {
    "id": "41wk9m9q0w8mnn",
    "cells": [
      {
        "columnId": "emv2qozw1jn5vo",
        "value": "pizza"
      },
      {
        "columnId": "emv2qjxv3pjo11",
        "dependencyStatus": "outOfDate",
        "sourceStatus": "readyForTranslation",
        "value": 60
      }
    ],
    "path": "Path Level 1/Path Level 2"
  }
]

To list records in a view.

The API returns one page of records at a time. Each page will contain a limit number of records, which is 100 by default. Use pagination to get next pages, use filtering or sorting to format the results.

HTTP Request

GET /v1/views/<viewId>/records?columnIds=<columnID_1>,<columnID_2>&fetchFileOption=<fetchFileOption>&page=<page>&query=<query>&sort=<sort>

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

columnIds optional

Specify data of what columns of view to include in response

fetchFileOption optional

Specify data of file cell in the response

page optional

Starting index and number of records. More details pagination here

query optional

Criteria to filter records. More details filtering

sort optional

Order of records. More details sorting here

Response

Returns a list of records in ARRAY if the get succeeded, otherwise, returns an error object if something goes wrong.

Make sure to replace {YOUR_API_KEY} and {VIEW_ID} with yours.

Add records

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/records' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '[
  {
    "id": "Record1",
    "path": "Path Level 1",
    "cells": [
      {
        "columnId": "{COLUMN_ID}",
        "value": "Pasta"
      }
    ]
  }
]'

OUTPUT

[
  {
    "id": "Record1",
    "cells": [
      {
        "columnId": "main_course",
        "value": "Pasta"
      }
    ],
    "path": "Path Level 1"
  }
]

To add new records to a view.

HTTP Request

POST /v1/views/<viewId>/records

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Request body

A request body has the format of a list and in raw-data. Every object in the list represents a single record resource and has the following format:

{ "id": <value>, "path": <value>, "cells": [ { "columnId": <value>, "value": <value> }, { "columnId": <value>, "value": <value> } ] }

Make sure to replace {YOUR_API_KEY}, {VIEW_ID} and {COLUMN_ID} with yours.

Response

Returns a list of added records in ARRAY if the adding succeeded, returns an error object if something goes wrong.

Update records

CODE

curl --location --request PATCH 'https://api.gridly.com/v1/views/{VIEW_ID}/records' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '[
  {
    "id": "{RECORD_ID}",
    "path": "Path Level 1"
    "cells": [
      {
        "columnId": "{COLUMN_ID}",
        "value": "Pasta"
      }
    ]
  }
]'

OUTPUT

[
  {
    "id": "v182ye104j8o33",
    "cells": [
      {
        "columnId": "main_course",
        "value": "Pasta"
      }
    ],
    "path": "Path Level 1"
  }
]

To update existing records of a view.

HTTP Request

PATCH /v1/views/<viewId>/records

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Request body

A request body has the format of a list and in raw-data. Every object in the list represents a single record resource and has the following format:

{ "id": string, "path": <value>, "cells": [ { "columnId": <value>, "value": <value> } ] }

Make sure to replace {YOUR_API_KEY}, {VIEW_ID}, {RECORD_ID} and {COLUMN_ID} with yours.

Response

Returns a list of updated records in ARRAY if the updating succeeded, return an error object if something goes wrong.

Update a single record

CODE

curl --location --request PATCH '<https://api.gridly.com/v1/views/44e84z0odnl2qm/records/currentRecordId'> \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '{
    "id": "newRecordId"
}
'

OUTPUT

{
  "id": "newRecordId"
  "cells": [
    {
      "columnId": "ingredient",
      "value": "onion"
    }
  ]
}

To update s single record of a view.

HTTP Request

PATCH /v1/views/<viewId>/records/<id>

Path parameters

Request body

Optional parameters

Response

Return database data in an object if succeeded. Otherwise, return an error.

Delete records

CODE

curl --location --request DELETE 'https://api.gridly.com/v1/views/{VIEW_ID}/records' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '{
  "ids": [
    "{RECORD_ID_1}",
    "{RECORD_ID_2}"
  ]
}'

To delete existing records of a view.

HTTP Request

DELETE /v1/views/<viewId>/records

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Request body

identifiers

[ { "id" : "string1-1", "path" : "path1" }, { "id" : "string1-2", "path" : "path1" } ]

Make sure to replace {YOUR_API_KEY}, {VIEW_ID} and {RECORD_ID} with yours.

Response

If successful, this method returns an empty response body.

Upload file

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/{VIEW_ID}/files' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--form 'file=@"/Users/john/Photos/pizza.jpg"' \
--form 'recordId="{RECORD_ID}"'
--form 'columnId="{COLUMN_ID}"'

OUTPUT

{
  "id": "v182ye104j8o33.jpg",
  "originalName": "pizza.jpg",
  "contentType": "image/jpeg",
  "size": 150516
}

To upload file to the cell of a view.

HTTP Request

POST /v1/views/<viewId>/files

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Multipart parameters

file required

Absolute file path of local machine.

recordId required

Id of the record.

columnId required

Id of the column.

Make sure to replace {YOUR_API_KEY}, {VIEW_ID} and {RECORD_ID} and ‘{COLUMN_ID}’ with yours.

Response

If successful, this method returns details of file structure in json format.

Download file

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/{VIEW_ID}/files/541617d3413147b0b365c87aae2b5a47.jpg' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

To download a file from the cell of a view.

HTTP Request

GET /v1/views/<viewId>/files/<id>

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

id required

FileId which was returned by upload file API

Make sure to replace {YOUR_API_KEY}, {VIEW_ID} and {RECORD_ID} with yours.

Response

If successful, this method returns the binary content of the file.

Delete file

CODE

curl --location --request DELETE 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/files?columnId=picture&recordId=v1lxdoj84e0v9o' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey yourApiKey' \
--data-raw '{
  "ids": [
    "xkd13v2wpmo19d.png",
    "1jld6w4o290d85.jpg"
  ]
}'

To delete files to the cell of a view.

HTTP Request

POST /v1/views/<viewId>/files

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Request parameters

recordId required

Id of the record.

columnId required

Id of the column.

Request body

Make sure to replace {YOUR_API_KEY}, {VIEW_ID} and {RECORD_ID} and ‘{COLUMN_ID}’ with yours.

Response

If successful, this method returns an empty response body.

Batch upload

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/{VIEW_ID}/files/zip' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--form 'file=@"/Users/john/Photos/pictures.zip"' \
--form 'columnId="{COLUMN_ID}"' \
--form 'fileMappings="{\"{RECORD_ID1}\":[\"rungtramtrasu.jpeg\",\"thotnot.jpeg\"],\"{RECORD_ID2}\":[\"chonoi.jpeg\"]}"'

OUTPUT

[
    {
        "id": "record1",
        "cells": [
            {
                "columnId": "file",
                "value": [
                    "3jjjljojy4q8q2q.jpeg",
                    "xnnn8nle5xldddd.jpeg"
                ]
            }
        ]
    },
    {
        "id": "record2",
        "cells": [
            {
                "columnId": "file",
                "value": [
                    "4555o5z59dv0p6p.jpeg"
                ]
            }
        ]
    }
]

To batch upload files to the cells of a view.

HTTP Request

POST /v1/views/<viewId>/files/zip

Parameters

viewId required

ID of the view. It can be found in the API quick start right panel of your Gridly Dashboard.

Multipart parameters

fileMappings

{ "record1": [ "rungtramtrasu.jpeg", "thotnot.jpeg" ], "record2": [ "chonoi.jpeg" ] }

Make sure to replace {YOUR_API_KEY}, {VIEW_ID} and ‘{COLUMN_ID}’ with yours.

Response

Returns a list of updated records in ARRAY if the updating succeeded, return an error object if something goes wrong.

Branch

List branches

CODE

curl --location --request GET 'https://api.gridly.com/v1/branches?gridId=3xep36emk4j1dq' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
  {
    "id": "v182ye104j8o33",
    "name": "Pizza"
  },
  {
    "id": "me6q2mvj4868l8",
    "name": "Burger"
  }
]

To list branches of a grid.

GET /v1/branches

Parameters

gridId required

ID of a grid.

Response

Return a list of branches in an array if succeeded. Otherwise, return an error.

Retrieve a branch

CODE

curl --location --request GET 'https://api.gridly.com/v1/branches/em8vw50wzkl111' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
  "id": "em8vw50wzkl111",
  "columns": [
    {
      "id": "ingredient",
      "name": "Ingredient",
      "type": "multipleLines"
    },
    {
      "id": "price",
      "name": "Price",
      "type": "number"
    }
  ]
}

To retrieve a branch.

HTTP Request

GET /v1/branches/<id>

Response

Return branch data in an object if succeeded. Otherwise, return an error.

Create a branch

CODE

curl --location --request POST 'https://api.gridly.com/v1/branches?branchId=xk0d5xz8j4xj6v' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--header 'Content-type: application/json' \
--data-raw '{
   "name": "Food"
}'

OUTPUT

{
  "id": "410nzk2op1zedp",
  "defaultAccessViewId": "me35v9mqd0e93y",
  "name": "Food"
}

To create a branch in a grid.

HTTP Request

POST /v1/branches

Parameters

branchId required

ID of a source branch.

Request body

Response

Return branch data in an object if succeeded. Otherwise, return an error.

Delete a branch

CODE

curl --location --request DELETE 'https://api.gridly.com/v1/branches/410nzk2op1zedp' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

To delete a branch.

HTTP Request

DELETE /v1/branches/<id>

Response

If successful, this method returns an empty response body.

Merge a branch

CODE

curl --location --request POST 'https://api.gridly.com/v1/branches/em8vw50wzkl111/merge?destinationBranchId=xk0d5xz8j4xj6v&mergeRecordOptions=add,update,delete,override' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--header 'Content-type: application/json'

OUTPUT

{
  "id": "410nzk2op1zedp",
  "status": "running"
}

To merge a branch to the branch.

HTTP Request

POST /v1/branches/<branchId>/merge

Request parameters

mergeRecordOptions

Response

Return asynchronous task of the request with id and status. To retrieve the latest status, check task api.

Task

Retrieve a task

CODE

curl --location --request GET 'https://api.gridly.com/v1/tasks/em8vw50wzkl111' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

{
  "id": "em8vw50wzkl111",
  "status": "successful"
}

To retrieve an existing task

HTTP Request

GET /v1/tasks/<id>

Response

Return task data of a task if succeeded. Otherwise, return an error.

Path

Create paths

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/paths' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '{
    "parentPath": "Movies",
    "paths": [
      "2022/Black Adam",
      "2023/Guardians of galaxy V3"
    ]
  }'

OUTPUT

{
  "paths": [
    "Movies/2022/Black Adam",
    "Movies/2023/Guardians of galaxy V3"
  ]
}

To create paths

HTTP Request

POST /v1/views/<viewId>/paths

Path parameters

Request body

Required parameters

Optional parameters

Update the leaf folder in the path

CODE

curl --location --request PUT 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/paths/Movies%2F2022%2FBlack%20Adam' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '{
  "newName": "White Adam"
}'

OUTPUT

{
  "path": "Movies/2022/White Adam"
}

To update the leaf folder in the path

HTTP Request

PUT /v1/views/<viewId>/paths/<path>

Path parameters

Request body

Required parameters

Move paths

CODE

curl --location --request POST 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/paths/moves' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '{
  "fromParentPath": "Movies",
  "toParentPath": "Games",
  "names": ["2022", "2023"]
}'

OUTPUT

{
    "paths": [
        "Games/2022",
        "Games/2023"
    ]
}

To move paths

HTTP Request

POST /v1/views/<viewId>/paths/moves

Path parameters

Request body

Required parameters

Delete paths

CODE

curl --location --request DELETE 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/paths' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}' \
--data-raw '{
    "parentPath": "Movies",
    "paths": [
      "2022/Black Adam",
      "2023/Guardians of galaxy V3"
    ]
  }'

To delete paths

HTTP Request

DELETE /v1/views/<viewId>/paths

Path parameters

Request body

Required parameters

Get path tree

CODE

curl --location --request GET 'https://api.gridly.com/v1/views/v1v9jwwk1lwnkz/paths/tree?rootPath=Movies' \
--header 'Content-Type: application/json' \
--header 'Authorization: ApiKey {YOUR_API_KEY}'

OUTPUT

[
    {
        "parentPath": "Movies",
        "name": "2022",
        "children": [
            {
                "parentPath": "2022", 
                "name": "Black Adam"
            }
        ]
    },
    {
        "parentPath": "Movies",
        "name": "2023",
        "children": [
            {
                "parentPath": "2023",
                "name": "Guardians of galaxy V3"
            }
        ]
    }
]

To get path in tree structure

HTTP Request

GET /v1/views/<viewId>/paths/tree?rootPath=

Path parameters

Query parameters