Mass Update

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

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

Mass update records

Request

Path
user_idstring(uuid)(User Id)required
badger_object_namestring(Badger Object Name)required
Bodyapplication/jsonrequired
identifier_field_namestring(Identifier Field Name)required
Example: "497f6eca-6276-4993-bfeb-53cbbbba6f08"
records_to_updateArray of strings(Records To Update)required
fields_to_updateArray of objects(Fields To Update)required
fields_to_update[].​badger_field_namestring(Badger Field Name)required
Example: "first_name"
fields_to_update[].​valueValue (string) or Value (integer) or Value (number) or Value (null)(Value)required
Any of:
string(Value)
curl -i -X PATCH \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/mass-update/{badger_object_name}' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>' \
  -H 'Content-Type: application/json' \
  -d '{
    "identifier_field_name": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
    "records_to_update": [
      "string"
    ],
    "fields_to_update": [
      {
        "badger_field_name": "first_name",
        "value": "string"
      }
    ]
  }'

Responses

Successful Response

Bodyapplication/json
idId (string) or Id (string)(Id)required
Any of:
string(Id)
statusstring(MassUpdateStatus)required
Enum"CREATED""FAILED""COMPLETED""IN_PROGRESS"
Example: "PENDING"
Response
application/json
{
  "id": "string",
  "status": "IN_PROGRESS"
}

Get mass update status

Request

Path
user_idstring(uuid)(User Id)required
mass_update_job_idstring(Mass Update Job Id)required
curl -i -X GET \
  'https://gridsquid.redocly.app/_mock/openapi/users/{user_id}/mass-update/jobs/{mass_update_job_id}/status' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

Responses

Successful Response

Bodyapplication/json
idstring(Id)required
Example: "497f6eca-6276-4993-bfeb-53cbbbba6f08"
statusstring(Status)required
Example: "PENDING"
errorsArray of objects(Errors)required
errors[].​record_idstring(Record Id)required
Example: "0010000083821D"
errors[].​error_messagestring(Error Message)required
Example: "Error"
Response
application/json
{
  "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
  "status": "PENDING",
  "errors": [
    { … }
  ]
}

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