Customer experience | Sales, Customer Insights,...

SSIS Kingswaysoft Integration tool can't map salesorderdetail

Like (0) Share

Report

Posted on 6 Nov 2020 16:35:03 by Tim Graf

Hello guys

I'm trying to get Records from an On-Prem Crm into a Online Crm with the SSIS Kingswaysoft Integration tool in Visual Studio. I'm having problems to migrate the salesorderdetail entity, because whenever I try to execute the task I get this error:

"An error occurred while validating input parameters: Microsoft.OData.ODataException: Does not support untyped value in non-open type."

Can anybody help me with that please? I'm already trying to solve this issue for hours and hours. Thank you in advance!

All responses (3)

Answers (0)

Suggested answer

rrizwann 675 on 09 Nov 2020 at 00:50:38

Like (0)

Report

RE: SSIS Kingswaysoft Integration tool can't map salesorderdetail

I had the same issue, but in my case the schema name didn’t work. I think it’s because my field is setup as a navigation property to either of two different entities. I found the correct name by pulling the metadata for the entity from the API and looking at the navigation properties. There were two navigation properties defined for this field, one for each target entity, so I had to use the name of the correct one in my payload.

<NavigationProperty

Name="parentcustomerid_account"

Type="mscrm.account"

Nullable="false"

Partner="contact_customer_accounts">

<ReferentialConstraint

Property="_parentcustomerid_value"

ReferencedProperty="accountid" />

</NavigationProperty>

The correct value was parentcustomerid_account above.
Suggested answer

Adrian Begovich 1,023 Super User 2025 Season 1 on 08 Nov 2020 at 22:50:38

Like (0)

Report

RE: SSIS Kingswaysoft Integration tool can't map salesorderdetail

Hi Tim Graf.

This issue is caused by passing a property of a JSON object that doesn't exist on the data model. Check your JSON for typos.
Suggested answer

Bipin D365 28,967 Moderator on 07 Nov 2020 at 14:38:03

Like (0)

Report

RE: SSIS Kingswaysoft Integration tool can't map salesorderdetail

Hi,

You will need to check the field schema name and verify if it is correct.

d365demystified.com/.../

You can use Rest builder to validate field schema name.

github.com/.../releases

Please mark my answer verified if i were helpful