Separating parameters from a list to individual fields

[floripaolo]

Hello

I am reading a list of numbers (comma separated) from a cell in Google sheets and I need to insert them individually to create a WP post.

Additionally those tags can vary in number. They can sometimes be 2, 3 or 4 (like in this case).

Thanks

[samliew]

Use {{ split(11.`D`; ",") }} in an iterator.

Use an array aggregator to map into the Values field (Turn on the “Map” toggle)

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

Read this

The Array Aggregator module allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

Here is an example of using the “Target structure type” of an Array Aggregator module:

As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.

[floripaolo]

HI

Thanks for that!

I’ve setup the aggregator, but I seem not to be able to map the actual data into the fields.

I tried mapping the arrays, the values, with numbers or without, but I always get an error message.

Or by mapping:

[samliew]

Okay, looks like you don’t need an iterator or aggregator.

Just {{ split(11.`D`; ",") }} directly into the Values field.

[floripaolo]

Thanks but I keep getting an error.

[samliew]

Your error comes from the other field, playlist, which is empty.

[floripaolo]

Right!

Now the tags work! Thank you!!

And I have an additional problem: playlists can be empty. how do I make ignore it and just leave the field empty?

[samliew]

You can use the built-in function ifempty with emptystring

e.g.:

{{ ifempty(variable; emptystring) }}

For more information, see

Links

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

[floripaolo]

H @samliew

Thanks for those links. I started the Academy a few days ago…

I actually came up with that same expression, but it doesn’t work for some reason…

I still get the same error message:

• Missing value of required parameter ‘values’.

[samliew]

Instead of emptystring, try:

• ignore

• space

[floripaolo]

None of them work…

[D_Sparrow]

Ive come across this error. Un-map (turn off mapping) that field so it is NOT updated. Now, add a New Update Wordpress Post module, this will only update 1 thing, can you guess? Now connect it to the original one but with a Filter that blocks the flow IF that variable IS Empty. HTH.

[floripaolo]

Nice workaround!!
Thanks a lot!!