cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hunainsami1
Helper I
Helper I

Use HTTP Get request trigger

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.
Screenshot_1.png

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

15 REPLIES 15
Expiscornovus
Super User
Super User

Hi @hunainsami1,

 

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

?$select=PositionId&cross-company=true

 

Let us know if that works. 

hunainsami1
Helper I
Helper I

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

hunainsami1_0-1614165594814.png

 

Expiscornovus
Super User
Super User

Hi @hunainsami1,

 

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

 

testquery_firefox.png

 

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#registe...

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

ManishJain
Solution Sage
Solution Sage

Hi @hunainsami1 ,

 

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

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.

ManishJain
Solution Sage
Solution Sage

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

Expiscornovus
Super User
Super User

Hi @hunainsami1,

 

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-servic...

 

dataverseintegration.png

 

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.

 

dynamicsvalues_d365hr.png

@ManishJain@ExpiscornovusI am using http trigger with get request, please see the screenshot attached below
Screenshot_2.png
Screenshot_1.png
@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.

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

 

Thanks

@ManishJainThe SQL does not update directly when the change is made on Position Details. We need to execute the batch job to update the data in BYOD SQL. We can't execute batch job after every change. So we can't use sql update trigger in this case, we need to trigger the flow in real time whenever the change is made in position details

hunainsami1
Helper I
Helper I

Hello PowerUsers,
Did anyone find the solution for this.

Since you already know when you are updating data why not invoke the flow on the same via your code. 

 

Thanks

There is not D365 HR update trigger to invoke a flow.

When I am using http trigger, it invokes the flow but it does not give us the exact details rather it returns all the entity data. Is there anything in url we can add to get the parameters directly from http url.

ManishJain
Solution Sage
Solution Sage

All I am saying is create a flow with only one parameter with HTTP request . Invoke this flow from your batch code. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,236)