Articles in this section

Review request and response errors in Salesforce

Kathyana Queeman
Updated

If your account is on EM 2.0, you can view the Salesforce HTTP request and response errors provided that both requests and responses result in an error and the Source is Application.

Importing data into Salesforce

  • SOAP

  • REST

  • Composite

Extract data from Salesforce

  • Scheduled flow with SOQL export

  • Real-time flow via Listener

Contents

Flow steps

The request and response errors integrator.io displays are determined by the flow steps.

Export errors

If you make an export or (dynamic) lookup request that results in an error, you can view the request and response in two separate panels in the Actions menu in the flow run dashboard. The error details will vary depending on where the export or lookup failed. Note that both the request and response must have errors.

Export examples

Protocol

Sample error details

SOQL REQUEST

 
{
  "method": "GET",
  "uri": "https://diksha-khatri-15-dev-ed.my.
          salesforce.com/services/data/v40.0/query/?q=SELECT%20Id%2C%20Name%2C%20ProductCode%2C%20Description%20FROM%20product2%20WHERE%
          20ProductCode%20!%3D%20''%20limit%201",
  "headers": {
    "Authorization": "********"
  },
  "maxResponseBytes": 26214400
}

SOQL RESPONSE

 
        {
  "headers": {
    "date": "Thu, 22 Jul 2021 06:39:20 GMT",
    "set-cookie": [
      "CookieConsentPolicy=0:0; domain=diksha-khatri-15-dev-ed.my.salesforce.com; path=/; expires=Fri, 22-Jul-2022 06:39:20 GMT; Max-Age=31536000",
      "BrowserId=izjEHeq3EeuyYcF_M7mnsQ; domain=.salesforce.com; path=/; expires=Fri, 22-Jul-2022 06:39:20 GMT; Max-Age=31536000"
    ],
    "strict-transport-security": "max-age=31536000; includeSubDomains",
    "x-content-type-options": "nosniff",
    "x-xss-protection": "1; mode=block",
    "x-robots-tag": "none",
    "cache-control": "no-cache,must-revalidate,max-age=0,no-store,private",
    "sforce-limit-info": "api-usage=52/15000",
    "content-type": "application/json;charset=UTF-8",
    "vary": "Accept-Encoding",
    "transfer-encoding": "chunked",
    "connection": "close"
  },

  "body": "{\"totalSize\":1,\"done\":true,\"records\":[{\"attributes\":
{\"type\":\"Product2\",\"url\":
\"/services/data/v40.0/sobjects/Product2/01t2v000009MIEaAAO\"},
\"Id\":\"01t2v000009MIEaAAO\",\"Name\":\"GenWatt Diesel 200kW\",\"ProductCode\":\"GC1040\",
\"Description\":null}]}"
}

Note

Response → Other sections will have at least these 2 fields:

{
"statusCode": XYZ,
"receivedAt": 1626873055700
}

Import errors

If you make an import request that results in an error, you can view the request and response in two separate panels in the Actions menu. The error details will vary depending on where the import failed. Note that both the request and response must have errors.

Import examples

SOAP

Protocol

Sample error details

SOAP REQUEST

 
        { "uri": { "protocol": "https:",
        "slashes": true,
        "auth": null,
        "host": "diksha-khatri-15-dev-ed.my.salesforce.com",
        "port": null,
        "hostname": "diksha-khatri-15-dev-ed.my.salesforce.com",
        "hash": null,
        "search": null,
        "query": null,
        "pathname": "/services/Soap/u/40.0/00D2v0000012nV4",
        "path": "/services/Soap/u/40.0/00D2v0000012nV4",
        "href":
        "https://diksha-khatri-15-dev-ed.my.
        salesforce.com/services/Soap/u/40.0/00D2v0000012nV4" },
        "method": "POST",
        "headers": {
        "User-Agent": "node-soap/0.24.0",
        "Accept":
        "text/html,application/xhtml+
        xml,application/xml,text/xml;q=0.9,*/*;q=0.8",
        "Accept-Encoding": "none",
        "Accept-Charset": "utf-8",
        "Connection": "close",
        "Host": "diksha-khatri-15-dev-ed.my.salesforce.com",
        "Content-Length": 877,
        "Content-Type": "text/xml; charset=utf-8",
        "SOAPAction": "\"\"" },
        "followAllRedirects": true,
        "body": " <!--?xml version=\"1.0\" encoding=\"utf-8\"?--> <soap:Envelope
        xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"
        xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:fns=\"urn:fault.partner.soap.sforce.com\"
        xmlns:tns=\"urn:partner.soap.sforce.com\"
        xmlns:ens=\"urn:sobject.partner.soap.sforce.com\"><soap:Header><urn:SessionHeader
        xmlns:urn=\"urn:partner.soap.sforce.com\">\n
        <urn:sessionId
        >00D2v0000012nV4!AQQAQF5iIJ6YEGc_
        XYU8tlZ2DmPGKAFxOJbGHgm81Lgztp0f
        LFHIWGJtK8_eYfUYOl0E78uTdMjzaRrzRiJNkB1CMl7MNYW3
        </urn:sessionId>\n
        </urn:SessionHeader>\n<urn:CallOptions
        xmlns:urn=\"urn:partner.soap.sforce.com\">\n
        <urn:client>Celigo/IntegratorDistributedAdaptor/
        </urn:client>\
        n</urn:CallOptions
        ></soap:Header><soap:Body>
        <create xmlns=\"urn:partner.soap.sforce.com\"
        ><sObjects>
        <ens:type
        xmlns:ens=\"urn:sobject.partner.soap.sforce.com\">Product2
        </ens:type></sObjects>
        </create></soap:Body></soap:Envelope>",
          "maxResponseBytes": 5242880 }

SOAP RESPONSE

 
        { "headers": { "date": "Wed, 21 Jul 2021 16:40:52 GMT", "set-cookie":
        [ "CookieConsentPolicy=0:0; domain=diksha-khatri-15-dev-ed.my.salesforce.com;
        path=/; expires=Thu, 21-Jul-2022 16:40:52 GMT; Max-Age=31536000",
        "BrowserId=aYFhkOpCEeuy_kOVu5OQKA; domain=.salesforce.com; path=/;
        expires=Thu, 21-Jul-2022 16:40:52 GMT; Max-Age=31536000" ], "cache-control":
        "no-cache,must-revalidate,max-age=0,no-store,private", "content-type":
        "text/xml; charset=utf-8", "vary": "Accept-Encoding", "transfer-encoding":
        "chunked", "connection": "close" }, "body": "
        <!--?xml version=\"1.0\" encoding=\"UTF-8\"?-->
        <soapenv:Envelope xmlns:soapenv=\
        "http://schemas.xmlsoap.org/soap/envelope/\"
        xmlns=\"urn:partner.soap.sforce.com\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">
        <soapenv:Header>
        <LimitInfoHeader><limitInfo><current>8
        </current><limit>15000</limit><type>API REQUESTS
        </type></limitInfo></LimitInfoHeader>
        </soapenv:Header><soapenv:Body><createResponse>
        <result><errors><fields>Name</fields>
        <message>Required fields are missing:
        [Name]</message><statusCode>REQUIRED_FIELD_MISSING
        </statusCode></errors>
        <id xsi:nil=\"true\"/>
        <success>false</success></result></createResponse>
          </soapenv:Body></soapenv:Envelope>" }

Note

Response -> Others section will have at least these 2 fields:

{ "statusCode": XYZ,
          "receivedAt": 1626873055700 }
REST

Protocol

Sample error details

REST REQUEST

 
{
  "relativeURI": "/services/data/v40.0/sobjects/Product2",
  "uri": "https://diksha-khatri-15-dev-ed.my.salesforce.com/services/data/v40.0/sobjects/Product2",
  "headers": {
    "Accept": "application/json",
    "Content-Type": "application/json",
    "Authorization": "Bearer ********"
  },
  "method": "POST",
  "json": {
    "id": "38",
    "Internal Id": "38",
    "SKU": "PRI00002",
    "Quantity": "19"
  },
  "followAllRedirects": true
}

REST RESPONSE

 
        {
  "body": [
    {
      "message": "No such column 'Internal Id' on sobject of type Product2",
      "errorCode": "INVALID_FIELD"
    }
  ]
}
COMPOSITE

Protocol

Sample error details

COMPOSITE REQUEST [similar to REST REQUEST]

 
{
  "relativeURI": "/services/data/v43.0/composite",
  "uri": "https://diksha-khatri-15-dev-ed.my.salesforce.com/services/data/v43.0/composite",
  "headers": {
    "Accept": "application/json",
    "Content-Type": "application/json",
    "Authorization": "Bearer ********"
  },
  "method": "POST",
  "json": {
    "allOrNone": true,
    "compositeRequest": [
      {
        "body": {
          "allOrNone": true,
          "records": [
            {
              "attributes": {
                "type": "Product2"
              },
              "Id": "38",
              "ProductCode": "1234"
            }
          ]
        },
        "method": "PATCH",
        "referenceId": "refProduct2",
        "url": "/services/data/v43.0/composite/sobjects"
      }
    ]
  },
  "followAllRedirects": true
}

COMPOSITE RESPONSE [similar to REST RESPONSE]

 
{
  "body": {
    "compositeResponse": [
      {
        "body": [
          {
            "success": false,
            "errors": [
              {
                "statusCode": "MALFORMED_ID",
                "message": "Product ID: id value of incorrect type: 38",
                "fields": [
                  "Id"
                ]
              }
            ]
          }
        ],
        "httpHeaders": {},
        "httpStatusCode": 200,
        "referenceId": "refProduct2"
      }
    ]
  }
}
BLOB

Protocol

Sample error details

BLOB export request

 
{
  "method": "GET",
  "uri": "https://d2e000000p4lxuaa-dev-ed.my.salesforce.com/services/data/v52.0/sobjects
/Document/0152E0000032bRTQAY123",
  "headers": {
    "Authorization": "Bearer *********"
  }
}

Blob export response

 
          [
  {
    "errorCode": "NOT_FOUND",
    "message": "Provided external ID field does not exist or is not accessible: 0152E0000032bRTQAY123"
  }
]

Blob import request

 
        {
  "uri": {
    "protocol": "https:",
    "slashes": true,
    "auth": null,
    "host": "d2e000000p4lxuaa-dev-ed.my.salesforce.com",
    "port": 443,
    "hostname": "d2e000000p4lxuaa-dev-ed.my.salesforce.com",
    "hash": null,
    "search": null,
    "query": null,
    "pathname": "/services/data/v52.0/sobjects/attachment/00P2E00001vlA6vUAE",
    "path": "/services/data/v52.0/sobjects/attachment/00P2E00001vlA6vUAE",
    "href": "https://d2e000000p4lxuaa-dev-ed.my.salesforce.com/services/data/v52.0/sobjects/attachment/00P2E00001vlA6vUAE"
  },
  "method": "PATCH",
  "headers": {
    "Content-Type": "multipart/form-data;boundary=boundary_string",
    "Authorization": "Bearer ****************",
    "host": "d2e000000p4lxuaa-dev-ed.my.salesforce.com"
  }
          }

Blob import response

 
          [
  {
    "message": "Unable to create/update fields: ParentId. Please check the security settings of this field and verify that it is read/write for your profile or permission set.",
    "errorCode": "INVALID_FIELD_FOR_INSERT_UPDATE",
    "fields": [
      "ParentId"
    ]
  }
]