Hi, I’m trying to create a collection like this: { “fps”: 30, “date”: {{now}} } I’ve been trying to figure out how to make an expression that can do it without using an extra operation and module like parse JSON. toCollection seems like it might work, but try as I might I can’t figure it out. T…

Hey there, what do you need this collection for? For the most part, you can type it in just like that directly inside the module you need it for. No need to transform it first.

I have a data store where each record has an array of collections. The collections have a pair of keys, one of which is a value (fps) and the other is the date when the value was sampled. There are a very large number of records and so I’m trying to keep ops to a minimum and avoid even one extra mo…

Both of those use parse JSON which I know how to do but want to avoid the extra module/Op. When you have a few million records the costs add up of extra steps.

Yeah you should be able to type in the same thing directly. Like here for example. They are using the JSON module to make it easier to manage, but yo should be able to type in the JSON structure inside the add() function directly and save on that operaion.

[image] Stoyan_Vatov: type in the JSON structure inside the add() function directly nooo… you cannot use JSON in an add function. It does not perform the parsing of JSON string to an object (Make collection variable) for you. Hope this helps! Let me know if there are any further questions or…

That didn’t work. I’d tried it before. [image] The operation failed with an error. Failed to map ‘data.fps_changes’: Function ‘add’ finished with error! Function ‘toArray’ finished with error! ‘{“fps”: “99”’ is not a valid collection.

Technically all we need is a built-in parseJSON function. I’m sure others would agree that this is a nice feature to have. You can submit this suggestion to the Idea exchange, under Platform Ideas and Improvements Don’t forget to search for it first, just in case someone already suggested it, so …

For some reason all semicolons are getting recognized and made parts of the formula. So the second semicolon is breaking it. You need to escape it and have a standard semicolon there instead of the one which is part of the formula.

How to create a collection without parse JSON

Questions

Stoyan_Vatov March 31, 2025, 12:59pm 5

So you want to add a collection to an array of collections? Here or here.

Topic		Replies	Views
Add a collection to array of collections Questions arrays	5	2333	October 16, 2023
Adding a collection item to an array Questions functions , arrays , collections	1	2158	December 13, 2023
Changing Collection into Array Questions arrays , collections	2	65	December 11, 2024
Aggregate collection for Chatgpt Questions arrays , collections , chatgpt	3	86	March 16, 2025
Add element to an array/collection Questions functions , arrays , collections	1	465	June 25, 2024

How to create a collection without parse JSON

Related topics