Mastering DataStore AddRow: Filling Array Fields on Make.com

Have you ever found yourself with a string like “A 1 B 2 C 3 D 4” of variable length and wondered how to fill an Array Field directly from a DataStore Add row or in just one additional operation? Well, you're not alone. This is a common challenge many of us face when dealing with data manipulation. But don't worry, there's a solution.

Step-by-Step Solution

Here's how you can tackle this problem:

  1. Start with a JSON Parser:
    • Input string: parse it to clear unwanted data
    • Generate collection JSON structure as { key1:value1, key2:value2}
    • Generate JSON array of collections
    • Don’t select a structure in the parser
  2. Then move to the DataStore AddRow module:
    • In map mode, assign directly the output of the JSON Parser module to the cell supposed to contain the array of collections

Troubleshooting Tips

If you're having trouble with the JSON Parser, make sure you're inputting the string correctly and clearing all unwanted data. Also, ensure that you're generating the correct JSON structure and array of collections. Remember, don't select a structure in the parser.

When using the DataStore AddRow module, ensure you're in map mode and correctly assigning the output of the JSON Parser module to the appropriate cell.

Conclusion

And there you have it! With these steps, you should be able to fill an Array Field directly from a DataStore Add row or in just one additional operation. Remember, practice makes perfect. Don't be discouraged if you don't get it right the first time. Keep trying and you'll get the hang of it. Happy coding!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.