Getting a Sting out of an Object - Logic Apps

-

So I ran into a rather annoying issue the other day. 

I had parsed some JSON in logic apps then and wanted to use the output in a condition statement. 

This is when the issue started for me. I tried the to String expression to turn the separate outputs into a string, however this didn't work. Not sure why I thought it would as that is never how it works but hey ho beginners mistake for sure.

I needed the string so that I could use it in a condition which kept breaking as I was passing an array into the condition rather than the string.

The work around I ended up using was to use the First() function to get the string from the array.

It worked like so:

I first used a Parse JSON on the object, as seen below





After you have Parsed your JSON you can choose whatever action you want to use but I will be using a compose action for this demonstration. After choosing an action instead of just choosing the "Useful Information" in dynamic content, I used an expression. The function I used for the expression was "First()" this enabled me to pull the string from the array. As seen below.

first(body('Parse_JSON')?['usefulInformation'])

Proof it works, 



Hope this helps, had me stumped for a while :)









Comments

Post a Comment

Popular posts from this blog

Finding all Network Interfaces that are connected to Virtual Machines in Azure

-
Image
Recently I was involved in a discovery project to find all our network interfaces and virtual machines in Azure. I was aware that you could go to the Network Interface dashboard or the Virtual Machine dashboard but this was too manual for my liking. Also I needed to know which Network Interface was used by which Virtual Machine. So my solution was using Azure Resource Graph Explorer.  The following KQL is used to get all Network Interfaces in your azure tenant.  resources | where type =~ 'microsoft.network/networkinterfaces' | extend privateIp = properties.ipConfigurations[0].properties.privateIPAddress | extend id = name | project name, privateIp, properties.macAddress, id Running this KQL gives me a output like this in my test tenant. To get the Virtual Machines that use the Network Interfaces a left outer join can be used to join the networkinterfaces table with the virtalmachines table using the IDs.  This is the KQL I used the left outer join.  | join kind=lefto...
Read more

AD PowerShell Script to see when a list of users last changed their passwords.

-
Image
A lot of companies have their ADs setup so that a users password will expire normally once every 6 months.  But what happens if the company was to do a password audit?  How would you know for certain that the users whose passwords were cracked had actually changed their passwords after being told to do so? Well quite simple you could ask them! But some would probably lie and say they did it when they most likely didn't. So an easier way to do this would to use a PowerShell script that imports a CSV file of all the users, then checks their AD accounts as each AD account has an attribute called PasswordLastSet. Why ask users when you can just check their accounts, at least this way you wont be lied to at all.  Below is a screenshot of my code used to run this as well as the results that came back.  I am more than happy for anyone to use this code, but take no responsibility if you change/modify this code in anyway to complete harmful/malicious actions.  Screenshot...
Read more

AD PowerShell script to add/remove a list of users from a group

-
Image
Have you ever had to do something manually and you were just like, I don't ever want to do that again it took to long.  Well that happened to me when I was setting up my domain and experimenting, I had to keep adding and removing my mock users to groups and it got really annoying.  So I simply automated it using PowerShell, know all I need to do is supply a list of the users I want to remove or add and the group name then voila.  To automate this I simply went through each line in the CSV file and got the distinguished name of the user using Get-ADUser. I then used either Add-ADGroupMember or Remove-ADGroupMember to add or remove the user, all that needed to be supplied here was the distinguished name of the group and the previously gotten distinguished name of the user.  Below is a screenshot of my code, I am happy for you to use it but I am not accountable if you edit or misuse and cause any issues.  Screenshot of the code: Results of running the code:
Read more