Unable to find the orders in IOM which were created with demo provider(E-commerce store)

(1) Share

Report

Posted on by Sreelatha N

When an order is placed using the demo provider (E-commerce store) I see an order getting successfully placed however it's not reflected in IOM.

I also noticed, the flow that triggers upon order creation has an error and the details are as below.

{

"@odata.context": "https://org76814c64.crm8.dynamics.com/api/data/v9.1/$metadata#Microsoft.Dynamics.CRM.msdyn_iomProviderTransformerResponse",

"Result": "{\"resultType\":\"Exception\",\"evaluationUsage\":{\"hourlyEvaluationCount\":4,\"dailyEvaluationTime\":220,\"hourlyEvaluationCountRemaining\":996,\"dailyEvaluationTimeRemaining\":359999780},\"message\":\"Expression.Error: The field 'accountid' of the record wasn't found.\",\"details\":[],\"errors\":[]}"

}

I tried creating a new customer whose details were the same as the demo customer and it was of no help.

Any documentation related to this issue/ demo order intake providers (apart from what is already available) will be of great help!

I have the same question (0)

All responses (5)

Answers (0)

RayBennett Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You need to setup mappings so that IOM knows how to relate the external customer to the internal customer.

I would think in the trial environment there would already be mappings setup, you would just need to use one of those customers that have the mappings.

learn.microsoft.com/.../internal-external-id-mapping

Was this reply helpful? Yes No
Sreelatha N 7 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response.

I was not able to find any mappings and tried configuring it as below.

The account used in an E-commerce store

The mapping in IOM

I still see the same error related to AccountId in the 'IOM Provider Transformer'.

Please let me know if I am missing anything!

Was this reply helpful? Yes No
RayBennett Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Don't specify Account, only Customer.

If that doesn't work, can you go to the failed run and copy/paste the source object?

When a call to IOM Provider Transformer fails, the best way of debugging this is by looking at the execution of the power automate directly

Navigate to your Power Platform portal for your environment

Open Solutions > Default Solution

Search for the cloud flow “IOM Provider Transformer”

Open it, and look at the 28 day run history

Find your execution and open it

Expand Try Process. Depending on your version of IOM, you may need to expand multiple nodes to find the call to the failed transformation step.

If successful, you can view the result of the transformation directly. If an Exception is thrown, the exception details can be seen by showing the raw outputs of the call.

Was this reply helpful? Yes No
Sreelatha N 7 on at

Like (0)

Report
Copy link

Link copied!

Hi RayBennet,

Updated the mapping setup by removing the Account and it still gives the same error.

The details of the exception remain same.

"body": {

"@odata.context": "org76814c64.crm8.dynamics.com/.../$metadata

"Result": "{\"resultType\":\"Exception\",\"evaluationUsage\":{\"hourlyEvaluationCount\":2,\"dailyEvaluationTime\":182,\"hourlyEvaluationCountRemaining\":998,\"dailyEvaluationTimeRemaining\":359999818},\"message\":\"Expression.Error: The field 'accountid' of the record wasn't found.\",\"details\":[],\"errors\":[]}"

}

Was this reply helpful? Yes No
RayBennett Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If that doesn't work, can you go to the failed run and copy/paste the source object?

Was this reply helpful? Yes No