Change Value in Array of Collections

Hey Guys,

I have this output. I would like to change the Price Value to 100 where ARID = 28268.
It should update TWO key/value pairs.

Any ideas please?

Thanks for your help! :slight_smile:

Welcome to the Make community!

Please provide the output bundles of the module [8] by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Screenshot_2023-10-06_141025

Providing the output bundles will allow others to replicate what is going on in the scenario.

This will allow others to better assist you. Thanks!

Could you format JSON code before submitting the reply, otherwise the forum software will convert some characters to make them invalid (checked when pasted into https://jsonformatter.org)

1.

Could you format your JSON by editing three backticks ``` before and after the code, like this:

```
input/output bundle goes here
```

2.

or use the format code button in the editor:
Screenshot_2023-10-02_191027

3.

Alternatively, you can paste and save the contents of the bundles in your text editor as a bundle.json file, and upload it here into this discussion thread.

Once the post has been submitted, it’s too late to format it, and you need to make a fresh copy of output bundle, and format it before submitting the forum post.

2 Likes

bundle.json (606 Bytes)
Thanks Sam!

You could set a new price variable like this, before the array aggregator module:

Then in the array aggregator module, uncheck the original price field, and select the new price variable.

Output:

Screenshot_2023-11-16_091129

Mate, that is very sneaky and awesome at the same time! :grinning:

Thank you so much!

No problem, glad I could help!

In future, please create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!

The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

2 Likes