Skip to main content

Hi everybody,

 

We have set up two external servers, the first for hosting our external database and the second for hosting the .Net solution.

We have exposed several methods for reading (GET), creating (POST), updating (PATCH and PUT) and deleting (DEL) data through this gateway in Odata.

All our tests from the Postman tool work correctly.

We then configured Salesforce Connect in Odata 4.00 version which we linked to this server.

We are successfully synchronizing two external objects named ArchivedEmailMessage and Subscription_ext.

We manage to insert data into these two tables which we can load for reading at the salesforce interface.

Deleting these records is also possible.

We are encountering difficulties updating this data which gives us a 405 method not allowed error.

The method applied by salesforce in "POST with X-HTTP-METHOD header set to PATCH" does not seem to be recognized by the method in .Net.

Having been unable to get a solution from support, we therefore upgraded the connector to Odata 4.01.

All parameters were set correctly which allowed us to operate the data insertion, reading and deletion methods.

Unfortunately, the update method still doesn't work.

We encountered error 400 which was resolved by removing control over the object model sent by salesforce.

A 500 error appeared after that and logs on the server recovered the following error: "Microsoft.OData.ODataException: An OData version of 4.01 was specified and the maximum supported OData version is 4.0."

We added additional code to try to correctly interpret Odata 4.01 but returned to a 400 error with logs stating that the model sent was null.

 

Does anyone have a solution for us?

0/9000