Records - Transformed

Grid Squid (1.0.0)

Download OpenAPI description
openapi.json
openapi.yaml
Languages
Servers
Mock server
https://gridsquid.redocly.app/_mock/openapi/
https://{yourDomain}.gridsquid.io/

Companies

group of users pointing to a specific CRM instance

Operations

Users

individual associated with a company in Grid Squid. Each user must authenticate with their individual CRM credentials (e.g., username and password or access tokens) to access CRM data, objects, and activities. Users share access to mappings and bulk imports created within their company.

Operations

Mappings

customizable workflow designed to extract, transform, and prepare CRM data for integration with other applications. Users can specify the CRM object (e.g., leads, opportunities) and define the fields required by the target system. Advanced transformations, such as validations, filtering and data quality checks, can be implemented using custom JavaScript. Mappings are created within a company and shared among all its users. The data retrieved through a mapping respects the access level and permissions of the individual user in the CRM.

Operations

Events

Notifications of changes occurring on the CRM side.

Operations

Records - Transformed

Manage CRM records applying your own mappings

Operations

Create record

Request

Path
user_idstring(uuid)(User Id)required
badger_object_namestring(Badger Object Name)required
Bodyapplication/jsonrequired
object(Body)
curl -i -X POST \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/records/unified/{badger_object_name}' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>' \
  -H 'Content-Type: application/json' \
  -d '{}'

Responses

Successful Response

Bodyapplication/json
object(Response Create Record Users User Id Records Unified Badger Object Name Post)
Response
application/json
{}

Get records

Request

Path
user_idstring(uuid)(User Id)required
badger_object_namestring(Badger Object Name)required
Query
limitinteger(Limit)
Default 100
curl -i -X GET \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/records/unified/{badger_object_name}?limit=100' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

Successful Response

Bodyapplication/json
itemsArray of objects(Items)required
Response
application/json
{
  "items": [
    {}
  ]
}

Get record

Request

Path
user_idstring(uuid)(User Id)required
badger_object_namestring(Badger Object Name)required
record_idstring(Record Id)required
curl -i -X GET \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/records/unified/{badger_object_name}/{record_id}' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

Successful Response

Bodyapplication/json
object(Response Get Record Users User Id Records Unified Badger Object Name Record Id Get)
Response
application/json
{}

Update record

Request

Path
user_idstring(uuid)(User Id)required
badger_object_namestring(Badger Object Name)required
record_idstring(Record Id)required
Bodyapplication/jsonrequired
object(Body)
curl -i -X PATCH \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/records/unified/{badger_object_name}/{record_id}' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>' \
  -H 'Content-Type: application/json' \
  -d '{}'

Responses

Successful Response

Bodyapplication/json
object(Response Update Record Users User Id Records Unified Badger Object Name Record Id Patch)
Response
application/json
{}

Delete record

Request

Path
user_idstring(uuid)(User Id)required
badger_object_namestring(Badger Object Name)required
record_idstring(Record Id)required
curl -i -X DELETE \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/records/unified/{badger_object_name}/{record_id}' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

Successful Response

Bodyapplication/json
any
Response
application/json
null

Records - Raw

Manage CRM records without applying your own mappings

Operations

Bulks

retrieval of large volumes of data from a CRM for a specific object.

Operations

Authentication

Connect your users to access the CRM on their behalf.

Operations

Mass Update

Update several records with just one API call using your mappings.

Operations

Metadata

Retrieve CRM metadata such as Objects, fields and users.

Operations

Netsuite Integration Credentials

Authenticate your Netsuite users.

Operations

Insightly Integration Credentials

Authenticate your Insightly users.

Operations

Netsuite Saved Search

Set up your Netsuite saved searches so you can retrieve records.

Operations

Netsuite Script Deployment

Set up your Netsuite Scripts to be run on mappings.

Operations