Customer experience | Sales, Customer Insights,...

call API by power automate and update a table from CRM

(0) Share

Report

Posted on by Nafas

160

Hi. I want to call an API from power automate and based on the response, update a table from CRM. anybody knows that how can I do this?

regards

I have the same question (0)

All responses (5)

Answers (0)

Nafas 160 on at

Like (0)

Report

Any idea?

Was this reply helpful? Yes No
Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report

Hi,

You can use below built in connector of Power Automate to send API request:

And you can configure the power automate trigger and after this you can use above connector send GET,PUT etc request:

example:

Once you receive the response then you can parse it using JSON parser as shown below:

Once you parse the data then add condition for CRM Update.
After this configure update field for table.

Now you are good go for test.

Hope this helps.

Thanks,
Pradeep Rai.

Please mark this as VERIFIED. If it helps.

Was this reply helpful? Yes No
Nafas 160 on at

Like (0)

Report

Hi. I do that but got error.

Was this reply helpful? Yes No
Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report

Hi,

Please check below link:

https://powerusers.microsoft.com/t5/General-Power-Automate/Handling-NULL-in-Parse-JSON/td-p/40906

For e.g.:

"heat_index_f": {
"type": ["number","null"]
},
"heat_index_c": {
"type": ["number","null"]
}

Thanks,
Pradeep Rai.

Was this reply helpful? Yes No
Suggested answer

SOUNDHARYA.N.V 165 on at

Like (0)

Report

From your screen shot for "href" it is defined as object but actual content is string

Change to string in the schema, then it should work. Check for other field schemas in the parse json step

Please mark this answer as verified if it helps you

Was this reply helpful? Yes No