Logic App Error when attempting to push to CRM

(0) Share

Report

Posted on by jasmine202020

I am trying to push some data into CRM utilizing the logic app and the parameter fields.
Some of the fields get pushed through, while others do not. I am trying to understand what is the logic behind this?

All of the fields go through except the LeadPM field. I get this error:
"message": "Syntax error: character '\"' is not valid at position 1 in '(\"Yu li\")'."

This is what I have done so far:

When I got this error, I added "" and this did not work, so then I added '' and this did not work either. I finally did not add any quotes and am still getting this error. Any insight on this would be greatly appreciated.

I have the same question (0)

All responses (7)

Answers (3)

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

What's type of Lead PM field and what do you pass inside?

Was this reply helpful? Yes No
jasmine202020 75 on at

Like (0)

Report

Hi it is a string like "John Yu" and I pass the dynamic field:

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

It seems that your field is a lookup. In this case your approach would not work. Format for the lookup field to update should look like

/entitynamerecordset(ID of the record) something like:

/contacts(89153C7D-E45E-E611-80F6-1458D05A5490)

Apply changes to the value you pass to the lookup field and you're ok.

Was this reply helpful? Yes No
jasmine202020 75 on at

Like (0)

Report

Hi Andrew,

Would it be something like this then?, because the name is already within the JSON...

The name is already within the JSON schema:

I am unsure how to write it dynamically. Please give me your suggestion.

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

I don't think that will work. You need the id of that relaated record and if you have only the name then you will have to get the id based on the name. You can use "List Records" step and get id from the result.

Was this reply helpful? Yes No
jasmine202020 75 on at

Like (0)

Report

Ok where can I find "List Records" step? I will look at this

Thank you

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Check following - docs.microsoft.com/.../connect-common-data-service

Was this reply helpful? Yes No