JSON Parse Fail with Azure Automation output

(0) Share

Report

Posted on by dennisb88

603

Hi All,

I've an Azure Automation script that's will be executed from my flow. With the script I create new Microsoft Teams.

As last point in my script I convert the Groupt-ID to JSON. (write-output $newteam | select GroupID | convertto-Json)

Because the Azure Automation runbook script has two outputs. (See image).

Output script.png

The first output is a default output, about my account and tenant information. I don't know how to skip this info as output. The second output is the expected output (the GroupId).

My Flow is failing because I receive both outputs.

Flow Output.png

This is failing my JSON Parse part in my flow. See second picture.

Did any one know what I need to do to skip the account/tenant output and only use the GroupID output?

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dennisb88

Before it hits the JSON Parser could you check the JSON data string value contains using an IF condition to make sure it's the right data structure you are passing to next step. Another way you could do is use flow exception handler under JSON Parser > Configure run after

Thanks

Was this reply helpful? Yes No
dennisb88 603 on at

Like (0)

Report

Hi @abm ,

Thank you for your reply.

I didn't realy understand what you mean with "Before it hits the JSON Parser could you check the JSON data string value contains using an IF condition to make sure it's the right data structure you are passing to next step." (Sorry I'm not have JSON skills)

But I think the complete issue is that my Automation Runbook send more output back to my flow than required.
Maybe are the follow printscreens helping to understand the issue:

I need only the groupId from the runbook output. But I get also the Run details from the runbook.
This is since two months. Before half november, it was working fine without the information about the Environment.

The setting "failed" doesn't help.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dennisb88

Because you mentioned the first & second output results I thought you must be getting two different set of JSON results one after the other. Looks like from the screen shot the output is below format:

Account : "ddd"
Environment : "ddd"
Tenant : "T"
TenantId : "TId"
TenantDomain :
{
"GroupdId": "123"
}

This is not a JSON record format anymore. Is that correct?

Thanks

Was this reply helpful? Yes No
dennisb88 603 on at

Like (0)

Report

Hi @abm ,

That's correct.
I know that the first part is not JSON. But that's the default output that I get as result after I run the Azure Automation Runbook. The runbook gives two output "objects" where only the second one is the right one:
I didn't know how I can skip that part of the output and get only the JSON output from Azure Automation.

Regards.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @dennisb88

It's a bit tricky because the output is not a JSON format. So try the below expression.

trim(replace(replace(replace(last(split(outputs('Compose_3'), 'GroupdId')), ':', ''), '}', ''), '"', ''))

Note: Above outputs('Compose_3') is where I input the test data.

Thanks

Was this reply helpful? Yes No
dennisb88 603 on at

Like (1)

Report

Hi @abm ,

Thank you! That was the trick!

I'm a happy guy at this moment!

Was this reply helpful? Yes No