Unanswered

Use HTTP Get request trigger

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Power Users,

I am using HTTP trigger GET request with specific url, which help me to run a flow whenever there is an update or action performed in this specific url entity.

The problem is, I am getting all the data of this entity, I just want to get the values which are being updated or created due to which the flow is triggered.
Please look into this and help me if there is any way to get these specific change.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (0)

Sort by

Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Can try if you can use a select in the URI field?

?$select=PositionId&cross-company=true

Let us know if that works.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The $select did not work. I am still getting all the entity data.

Was this reply helpful? Yes No
Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

What do you get when you test the same GET request in a browser like FireFox?

And have you setup the authentication for the HTTP action with an application in Azure AD?

https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-developer-api-authentication#register-a-new-application-by-using-the-azure-portal

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

When I am hitting the url directly on browser I am also getting the same result as you are showing in your image. and for authentication, I already have setup it and using odata http calls in different flows.
But I think I didnt put my question clearly here, I want to get only one value due to which the flow is triggered. For example, When I am creating or updating position details the flow get triggered, here I want to get only this value which is being changed or updated not all the entity data.
For example, If I updated positionId "005258" in position details, Then in flow I should get only this position Id.

I think I have described it well now.

Regards
Hunain

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In order to select based on particular field add $filter = fieldname eq value in the url after select
eg. ?$select=PositionId&cross-company=true&$filter = positionid eq '0000003'

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I know the odata filtering but I dont know the position id which is being updated or created. The flow triggered automatically whenever there is any change in position details, but I am getting all the data in this run, isnt there a way that I only get this specific row value which is changed.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

I am not sure which connector you are referring to here . Can you please tell me that

Was this reply helpful? Yes No
Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Like @ManishJain I am also not really sure which trigger or connector you are referring to.

However, I do understand a bit better what you want.

If allowed, you could potentially setup/enable the Dataverse integration for one or more tables from Dynamics 365 Human Resources:

https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-admin-integration-common-data-service

When that is enabled you could use the when a row is created, updated or deleted trigger action to get the specific record which has been created or updated.

For that specific record you can retrieve the value of a specific field via a dynamic value.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ManishJain @ExpiscornovusI am using http trigger with get request, please see the screenshot attached below

@Expiscornovusyou get it right now I want to do the same but with HTTP not Dataverse. As we don't have integrated dataverse. We have integrated SQL and can not move to dataverse now we are already setup with SQL. There is update create trigger in SQL as well but it is not directly synced with D365 HR we have to sync with batch job each time so We can not use this trigger here.
Thanks for investing this much time on this. It would be really appreciated if someone can give me a way to achieve this.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

So why not use SQL Server Connector with on premise gateway which will work on update of record.

Thanks

Was this reply helpful? Yes No