Sign Up ›
  • Dmitriy Reznik
  • NEWBIE
  • 0 Points
  • Member since 2021
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
1 replies

502 error recieved while trying to upsert records via API, using the azure connector

We are recieving the following request from 3rd party system which use the azure connector. The purpose is the upsert accounts by using the field Email as the external ID. This happens when we do the operation on specific email address

Request
-------------
{
"method": "patch",
"path": "/datasets/default/tables/Account/externalIdFields/Email__c/[EMAIL]",
"host": {
"connection": {
"name": "/subscriptions/<num>/resourceGroups/Acceptance/providers/Microsoft.Web/connections/salesforce"
}
},
"body": {
    <body>
}
}

Response
--------------
{
"statusCode": 502,
"headers": {
"Pragma": "no-cache",
"x-ms-datasourceerror": "True",
"x-ms-request-id": "aba6d55c-c48c-463d-8ef3-20f013175c66",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Cache-Control": "no-store, no-cache",
"Date": "Tue, 17 Mar 2020 12:51:06 GMT",
"Set-Cookie": "ARRAffinity=9a53c9d953bbdfc85fcb9bc388522492211961687fcde0ee871a9a717de0c346;Path=/;HttpOnly;Domain=salesforce-we.azconn-we.p.azurewebsites.net",
"Content-Length": "608",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"error": {
"code": 502,
"source": "logic-apis-westeurope.azure-apim.net",
"clientRequestId": "aba6d55c-c48c-463d-8ef3-20f013175c66",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Salesforce failed to complete task: Message: Error converting value \"/services/data/v34.0/sobjects/Account/0018E00001L57iUQAR\" to type 'Salesforce.Common.Models.ErrorResponse'. Path '[0]', line 1, position 59.\r\nclientRequestId: aba6d55c-c48c-463d-8ef3-20f013175c66",
"error": null,
"source": "Newtonsoft.Json",
"errors": []
}
}
}
}

Really appreciate your feedback