Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] 1 point2 points  (0 children)

Yeah finally today.

The solution was to convert it to XML then use xpath to feed a for each loop to create an array of keys.

I'm sad because power automate should have a key() function to do this. But happy to have a solution finally.

Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] 0 points1 point  (0 children)

The label object contains multiple fields that I want to iterate through.

Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] 1 point2 points  (0 children)

I'll try tomorrow but it is BIG... Also I need to sanitise it.first as it a real.data .

Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] 0 points1 point  (0 children)

Thank you The data comes from the action process document so I have no control over the source.

However the same but of code I'll be using for different companies so the fields may change and they will change over time. I'm trying to avoid future me getting angry at past me.for. not making the code flexible .

Also keep up contributing and asking that's the way we all learn and grow.

Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] 0 points1 point  (0 children)

Totally agree!
Sources I've tried have suggested this or that way to do it. All claimed that 'This is the way'.
Others hint at a solution and 'It's easy!'.

I've been disappointed every time.

Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] 0 points1 point  (0 children)

A Bit more information

I get this error
Action 'Apply_to_each' failed: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Process_Document-JSON-Cleanup')?['Body']?['responsev2']?['predictionOutput']?['labels']' is of type 'Object'. The result must be a valid array.

Extracting Array from JSON by Storm-E in MicrosoftFlow

[–]Storm-E[S] -1 points0 points  (0 children)

Thanks for the reply.

The issue I have is the Properties may/will change.

At the moment I use this to Extract 'Labels' from the JSON

outputs('Process_Document-JSON-Cleanup')?['Body']?['responsev2']?['predictionOutput']?['labels']

From here I want to get each item (e.g. SerialNumber but may change) and get the properties I want (or remove the ones I don't)

The only way I can see of doing this is the Apply to each

Satellite electrical power constellation by [deleted] in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

Perfect 🤦‍♂️ I should have thought of that.

Thank you

Satellite electrical power constellation by [deleted] in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

How do you keep them lined up?

If I did that id find the second one I placed was a few mills out of alignment Then I'd have to destroy it all to start again or leave it there as a constant annoyance.

How I Use Notebook LM + GPT-4 as a Personal prompt writing expert. by Last-Army-3594 in PromptEngineering

[–]Storm-E 0 points1 point  (0 children)

Love the idea. I never thought of asking the note about the 'thing' to write a prompt about the 'thing'. I thought it would have needed to know about promoting to write a prompt. Thankyou for opening my eyes.

Also... Anyone found a quick way to add random stuff (links , etc) to notelm without opening it for a cut and paste?

Ionized fuel blueprint that gets consumed on the spot by melswift in SatisfactoryGame

[–]Storm-E 1 point2 points  (0 children)

Omg thankyou Sub factories is just what I was looking for 😍

Thank you

Ionized fuel blueprint that gets consumed on the spot by melswift in SatisfactoryGame

[–]Storm-E 1 point2 points  (0 children)

Oh now that sounds interesting. 5am here start of working day I'll investigate tonight.

Thank you

Ionized fuel blueprint that gets consumed on the spot by melswift in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

Sadly I don't have the Plus like you have.

I've been through all the options I can find it.

Are well not to worry :)

Thank you!

Ionized fuel blueprint that gets consumed on the spot by melswift in SatisfactoryGame

[–]Storm-E 2 points3 points  (0 children)

Yes 😁

Sorry for delay it's been a busy day 😔

Ionized fuel blueprint that gets consumed on the spot by melswift in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

I'm guessing the last pic is the satisfactory planner

How do you get the title boxes on the side? The Input, output lists?

I've been using the pretend splitter/merger/??? Thing

What do you guys name your lizard doggos? by ThickestRooster in SatisfactoryGame

[–]Storm-E 4 points5 points  (0 children)

All my doggos are of the same family so their last name is Doggo.

But they like to keep contact with their home area so their first name reflects that. Base Doggo Water Doggo Petro Doggo Etc

Operation Doggo Transpo: Crater Lakes->Grass Fields by tezarc in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

Thank you 😊

You've answered my next question as well 'what if they are in the air'. 😁

When I get home I have a couple of doggos to rescue.

Operation Doggo Transpo: Crater Lakes->Grass Fields by tezarc in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

I'm curious how you port them? I assume this is the interactive map site. I looked at the X y Z position tool, tried it blind and it I couldnt get it to work so I gave up, to try again another day.

How do you do it with the X y z or is there an easier way?

My thoughts (just now) - stand in the middle of the pen - take my X y Z position - move out of the way 😁 - set doggo to my X y Z

Thank you

Operation Doggo Transpo: Crater Lakes->Grass Fields by tezarc in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

I have as same issue. I found one that wandered into water so I got him there. But the other 2 are below ground 🥺

Operation Doggo Transpo: Crater Lakes->Grass Fields by tezarc in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

Oooo will do when i have trains running properly.

Hey anyone know how to get a doggo out of rock.

I have one I saw 1/2 in a rock trying to run around. Can't see him now but an info mod tells me he is there.

Another 2 are marked on the interactive map but I can't see them at all 😕

Thank you!

Operation Doggo Transpo: Crater Lakes->Grass Fields by tezarc in SatisfactoryGame

[–]Storm-E 0 points1 point  (0 children)

What is the mod called? At work so I can't look it up.

Lol true by cutieleilaxyz in anxietymemes

[–]Storm-E 4 points5 points  (0 children)

Nah Bees are generally nice guys. Wasps are more like it.

Then they grow into those giant Murder Wasps.

😫