I receive my data via JOTFORMS, in an accessible json object with each field available to the scenario, but there are 21 lines with 11 fields each.
How do I turn the line items into induvial bundles with all its data such as Name, ID, type qty price etc. (Of course after i make these bundles ill do additional actions with the data. But my problem is iterating, or aggerating? this is my problem lol)
Welcome to the Make community!
Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.
You can upload images here using the Upload icon in the text editor:
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Uploading it here will look like this:
blueprint.json (12.3 KB)
Please provide the output bundles of the Jotform module by running the scenario, then click the white speech bubble on the top-right of each module, save the contents as a text .json file, and upload it here into this discussion thread:
Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!
blueprint (3).json (56.9 KB)
bundle.json (6.9 KB)
Here is a screenshot of 1 action, the blueprint for 1 action, and the output bundle of 1 service. SMH
@samliew do you have any suggestions?
Can you put a “Transform to JSON” module after your Jotform module, and send me the output bundle?
This is because I think you can parse the raw JSON like this instead to individual bundles:
Like this:
wow i didnt know you could do that with regex.
Here is my output, i tried copy and pasting what you had on the regex site for a patern but it didnt match.
output.json (7.4 KB)
Here’s the updated value for the Text Parser “Match Pattern” module regular expression pattern field:
"q\d+_name\d+":"(?<name>.*?)","q\d+_stype\d+":"(?<stype>.*?)","q\d+_qty\d+":"(?<qty>.*?)","q\d+_price\d+":"(?<price>.*?)","q\d+_type\d+":"(?<type>.*?)","q\d+_colab\d+":"(?<colab>.*?)","q\d+_colabbrand\d+":"(?<colabbrand>.*?)","q\d+_origin\d+":"(?<origin>.*?)","q\d+_metrc\d+":"(?<metrc>.*?)","q\d+_rnd\d+":"(?<rnd>.*?)","q\d+_secunit\d+":"(?<secunit>.*?)"
Test/demo: https://regex101.com/r/Wjc1jk
Make sure “Global match” is set to Yes. This is because you want all matches as individual bundles.
Do not need to add / to the start and end of the pattern field value.
For more information, see Text Parser in the Make Help Center:
Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.
- The complete list of metacharacters can be found on the MDN web docs website.
- For a tutorial on how to create regular expressions, we recommend the RegexOne website.
- For an easy, quick regex generator, try the Regular Expressions generator.
- For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.
Hope this helps!
Hmmm i updated the pattern but it still not matching.
I even went to the regex website and pasted in my output and it matches on there but not on make.
Try copying the pattern from above again, ensure that the patten field only begins and end with a ". Do not need to add / to the start and end of the pattern field value.
If you are still having issues,
Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Uploading it here will look like this:
blueprint.json (12.3 KB)
Got it! its now matching.
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:
To do this, simply click the checkbox at the bottom of the post that answers your question:
Thanks Sam, this was all 1 question trying to figure out how to bundle the data. I guarantee that this will be a game changer to many people searching the community for more difficult scenarios.
