Concatenation in XPath

My customer had a requirement to be able to combine the data from multiple XML elements into a single field within their corporate TechnologyOne Property & Rating system as part of an integration with the NSW Planning Portal. Thankfully, the target system allows you to configure Data Controls to place XML elements into, and you … Read more

APIM send-request to self

I had a scenario that required multiple send-requests to be executed inside a policy. One of the send-requests needed to be made to another API operation hosted on the same APIM instance. Using the FQDN resulted in a HTTP 404 not found response. The following can be used within a policy if you need to … Read more

XPath If Statement Alternative

I needed to configure some data mapping in a customers TechnologyOne Property & Rating system for an inbound HTTP request that contained XML in the request body. To retrieve values from the XML, I could create what is called an External Data Control to store a value in, and then map the External Data Control … Read more

Generate and cache OAuth 2.0 tokens using Azure API Management

Are you using Azure API Management to forward requests on to an external API service that requires OAuth tokens for authorization? In this post we will cover how you can use policy in APIM to automatically generate and cache OAuth 2.0 tokens and include the tokens in headers before forwarding requests to the backend. The … Read more

Add a New Row to Dataverse – URL was not parsed due to an ODataUnrecognizedPathException

Are you trying to Add a New Row to Dataverse using a Power Automate Flow and receiving the following error? URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL. Are you populating a lookup field with the guid of the record you are trying to relate … Read more

Power Automate: Get HTTP Status Code and Output from a non-HTTP action

I came across the requirement today where I had a HTTP triggered Flow that was being called by another application. The Flow was making some insertions to Dataverse using the Add a new row Action. I needed to return the HTTP response (and error message if it failed) to the client application. I am used … Read more

Secure a HTTP Triggered Power Automate Flow with OAuth

I needed to securely send data to a Dataverse environment in a client’s tenant from my Azure tenant. The target endpoint listening for HTTP requests to consume the data was a HTTP triggered Power Automate Flow. As HTTP triggered Power Automate Flow’s are natively exposed to the Internet, I needed to find a way to … Read more