Adam Gatt
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
Check if an array is empty in Power Automate Flows and Logic Apps
My instinct was to try and use not equal to null. When that failed I considered checking length, but it turns out there is a much neater way: I used that expressions inside a Condition action with a is equal to true
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