How to delete F&O Purchase Order in Logic Apps using HTTP?

Joel Fernandez 0

Can you show me step by step on how to delete a purchase order in Logic Apps using HTTP?

2 answers

MayankBargali-MSFT 70,536 Reputation points

2023-10-16T03:41:01.9833333+00:00

@Joel Fernandez Thanks for reaching out.

Assuming that you want to use the HTTP Trigger and delete the F&O record.

Workflow:

HTTP Trigger --> Delete Record

Based on your input on your body you can leverage the dynamic parameter and use it in the Delete record action to delete the record.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.
Please sign in to rate this answer.
Joel Fernandez 0 Reputation points

2023-10-16T14:05:36.45+00:00

@MayankBargali-MSFT , Thanks for replying. I think you're referring to HTTP as a trigger and then call the Delete record to delete a record. What I meant is to delete a record using HTTP instead of Delete record. Is that possible? The reason is this:

I have a process where I need to delete an open purchase order (Approval status=Draft; Purchase order status=Open order) with no line items. I have no issue deleting purchase orders under my account's company (dataAreaId) as shown below:

The issue is when I try to delete a purchase order under a different company, I am getting the error, "An error has occurred. No resources were found when selecting for update."

MayankBargali-MSFT 70,536 Reputation points

2023-10-18T04:00:47.6733333+00:00

@Joel Fernandez From the logic app perspective yes you can call any HTTP endpoint using the HTTP action. If you already have tested the delete F&O API using fiddler/postman, then I can assist you to replicate the same in the HTTP connector. In case if you need any help to build request, parameter then dynamics experts can assist you here.

Joel Fernandez 0 Reputation points

2023-10-19T14:05:57.9966667+00:00

@MayankBargali-MSFT I found articles on how to delete records using HTTP. I'm currently working on it and revert to you on the outcome. Thanks again.

Joel Fernandez 0 Reputation points

2023-10-19T14:07:53.2+00:00

@MayankBargali-MSFT I found articles on how to delete records using HTTP. I'm currently working on it and will revert to you on the outcome. Thanks again.

Joel Fernandez 0 Reputation points

2023-10-30T22:09:27.7266667+00:00

@MayankBargali-MSFT I'm back. But unfortunately, I haven't resolved the issue yet and in need of your assistance again.

I set up the App Registration for F&O and get the token. When retrieving data via HTTP, I am getting no results for PurchaseOrderHeadersV2. Any idea?

Input:

Output:

MayankBargali-MSFT 70,536 Reputation points

2023-10-31T05:32:57.74+00:00

@Joel Fernandez Dynamics 365 team can assist in validating the request. As per your screenshot we can see 200 response from the dynamics endpoint with no result so that means either there is no data that is retrieved for your configured request. I will suggest you to reach out to dynamics experts here as Dynamics 365 is not currently supported here on QnA ands they can assist you in validating it using fiddler/postman etc. In case if you need any assistance from logic app end then feel free to reach out to me.

Joel Fernandez 0 Reputation points

2023-10-31T14:01:59.4933333+00:00

@MayankBargali-MSFT I have posted the question at the other forum as you suggested. Thanks again for your assistance.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Joel Fernandez 0 Reputation points

2023-11-06T16:15:24.7933333+00:00

@MayankBargali-MSFT I figured out the solution. Here are the steps I took:

First, I updated the user associated with the client ID to my own user ID (which has admin privileges).

Second, I added the option cross-company=true to search the purchase order from all company entities. This did not work prior to changing the user ID in the first step.

Here are the references that helped me out:

https://www.youtube.com/watch?v=ZXLTfbWc9S4

https://www.youtube.com/watch?v=gNl6kaLxDXY&t=105s
https://www.youtube.com/watch?v=MGJx0FXGR3Q
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to delete F&O Purchase Order in Logic Apps using HTTP?

2 answers

Your answer