You need to sign in to do that
Don't have an account?
Ima Hema
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
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
Dmitriy Reznik
I have the same issue :(