Articles in this section

The Celigo platform’s canonical format for mock data

You can use mock output to simulate export or mock response import data when configuring flows. Instead of actually executing the export to retrieve sample data (or waiting for webhook listeners to receive data), integrator.io uses the mock output you provide to simulate export data (or mock response to simulate import response data) while you are configuring your flow. Mock data must be in the integrator.io canonical format for JSON.

Note

Webhook listeners always use the canonical format for record data.

Canonical format for record data

{
   "page_of_records"  :[
     {
         "record"  :{
            "id"  :  "12345"  ,
            "name"  :  "Mary Poppins"  ,
            "type"  :  "customer"  ,
            "address"  :{
               "street"  :  "17 Cherry Tree Lane"  ,
               "City"  :  "London"
           }
        }
     },
     {
         "record"  :{
            "id"  :  "98765"  ,
            "name"  :  "Sherlock Holmes"  ,
            "type"  :  "customer"  ,
            "address"  :{
               "street"  :  "221B Baker Street"  ,
               "City"  :  "London"
           }
        }
     }
  ]
}

Canonical format for rows data

{
    "page_of_records": [{
        "rows": [{
            "id": "12345",
            "name": "Mary Poppins",
            "type": "customer",
            "address": {
                "street": "17 Cherry Tree Lane",
                "City": "London"
            }
        },
        {
            "id": "98765",
            "name": "Sherlock Holmes",
            "type": "customer",
            "address": {
                "street": "221B Baker Street",
                "City": "London"
            }
        }]
    }]
}

Canonical format for mock response data

[
    {
        "id": "1234567890",
        "errors": [],
        "_json": {
        "mockResponse": "replace me"
        },
        "statusCode": 200,
        "ignored": false,
        "dataURI": "",
        "_headers": {
            "content-type": "application/json; charset=utf-8"
        }
    }
]

Canonical format for NetSuite

{
    "id": 478945,
    "statusCode": 200,
    "_json": {
        "id": 478945
    },
    "ignored": false,
    "errors": [],
    "dataURI": ""
}

Canonical format for Salesforce Composite

{
    "statusCode": 200,
    "id": "0010o000037gWjsAAE",
    "_json": [
        {
            "body": [
                {
                    "id": "0010o000037gWjsAAE",
                    "success": true,
                    "errors": []
                }
            ],
            "httpHeaders": {},
            "httpStatusCode": 200,
            "referenceId": "refAccount"
        }
    ],
    "errors": []
}

Canonical format for Salesforce Rest

{
    "statusCode": 200,
    "id": "0010o000037gWmyAAE",
    "_json": {
        "id": "0010o000037gWmyAAE",
        "success": true,
        "errors": []
    },
    "_headers": {
        "date": "Fri, 25 Aug 2023 11:50:41 GMT",
        "sforce-limit-info": "api-usage=10/15000"
    },
    "errors": []
}

Canonical format for Salesforce Soap

{
    "statusCode": 200,
    "id": "0010o000037gWmtAAE",
    "_json": {
        "id": "0010o000037gWmtAAE",
        "success": true
    },
    "

Canonical format for API requests

{
  "pathParams": {
    "storeId": "samplestoreId"
  },
  "queryParams": {
    "petType": "sample petType"
  },
  "headers": {
    "customHeader": "sample customHeader"
  },
  "body": {
    "pets": [
      {
        "id": 1,
        "name": "sample name",
        "type": "sample type",
        "age": 1,
        "status": "sample status"
      }
    ]
  }
}