Skip to main content

Review request and response errors in Salesforce

Kathyana Rule
  • 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"
    ]
  }
]

Related articles

Comments

0 comments

Please sign in to leave a comment.