Logic apps Salesforce create record using Connector returns 404

Question

Hi

We are experiencing similar errors to this unanswered question:

https://learn.microsoft.com/en-us/answers/questions/245852/create-salesforce-platform-event-from-azure-logic.html

input request:

{  
    "method": "post",  
    "path": "/datasets/default/tables/CMUpdate__e/items",  
    "host": {  
        "connection": {  
            "name": "/subscriptions/mySubscriptionId/resourceGroups/myResourceGroup/providers/Microsoft.Web/connections/salesforce"  
        }  
    },  
    "body": {  
        "OfficialName__c": "Testing org",  
        "OfficialStreet__c": "Testing street 1",  
        "OfficialCity__c": "xxx",  
        "OfficialCountryCode__c": "xx",  
        "OfficialPostalCode__c": "123455",  
        "OfficialPhone__c": "123456767",  
        "myRefId__c": "123456783",  
        "OrganisationNumber__c": "5555-1555",  
        "CompanySizeCode__c": "3"  
    }  
}  

output response:

{  
    "statusCode": 404,  
    "headers": {  
        "Pragma": "no-cache",  
        "x-ms-request-id": "9172af1a-ac2c-4765-b9c6-ba0fe06ec69c",  
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",  
        "X-Content-Type-Options": "nosniff",  
        "X-Frame-Options": "DENY",  
        "Cache-Control": "no-store, no-cache",  
        "Set-Cookie": "ARRAffinity=9227faf24135ad53dd065beee547fecb0ff01774dd3486105eba5bed7b415073;Path=/;HttpOnly;Secure;Domain=salesforce-we.azconn-we.p.azurewebsites.net,ARRAffinitySameSite=9227faf24135ad53dd065beee547fecb0ff01774dd3486105eba5bed7b415073;Path=/;HttpOnly;SameSite=None;Secure;Domain=salesforce-we.azconn-we.p.azurewebsites.net",  
        "Timing-Allow-Origin": "*",  
        "x-ms-apihub-cached-response": "false",  
        "Date": "Thu, 10 Jun 2021 08:07:07 GMT",  
        "Content-Length": "186",  
        "Content-Type": "application/json",  
        "Expires": "-1"  
    },  
    "body": {  
        "error": {  
            "code": "",  
            "message": "The field 'Id' is not part of the 'CMUpdate__e' table."  
        },  
        "debugInfo": "clientRequestId: 9172af1a-ac2c-4765-b9c6-ba0fe06ec69c"  
    }  
}  

Salesforce admin confirms that the "platform-event" is successfully created.

That the connector returns an error is unacceptable

Answer 1

anonymous user-8003 Can you confirm if your table CMUpdate__e does not have the Id column. The salesforce connector logic based on assumption that every table is derived from the default “Standard Object” type, that has an Id column. You can verify if your table CMUpdate__e has Id column or not using Salesforce Workbench.

We will document this behavior for now and I have already passed the feedback to the team if this can be enhanced in future.