New FREE Plugin - JSON Machine. Work with JSON direct on the page

marcosandrepennacout · 2021-02-24T18:18:15.377Z

Thanks for the help Jon,
I will try this…

marcosandrepennacout · 2021-02-24T23:07:07.438Z

UAu, totally unexpected! Insane behavior detected. My DB User has a data called json with the typical JSON text of the heroe ́s squad provided as an example ! Okay, perfect… but it seems that by changing the text within the DB User field called json… it continues with the hero’s squad data! When creating a field in this same DB User called jsonc, to test another JSON, he does not accept reading this new field! I’m finding it very strange… would it be a bug? Is there a limitation of what we can use? Is my JSON text incorrect? (I think it’s the last most likely option) … the triall and error mode keeps going…

jon2 · 2021-02-25T04:55:55.344Z

User testing in preview can be tricky. I’d double check and make sure you are testing the user that you think you are. You can display the current users email. This sounds like a permissions issue.

Good luck

marcosandrepennacout · 2021-02-25T16:05:44.195Z

Jon, you rulles dude.
Indeed it was a current user issue…
whem i register and log in a user it updated! Strange preview´s peculiarity…
Are you from Bubble team, or do you have only Json MAchine plugin? If you´re not from bubble, they should consider contracts you!
Thank you very much for your help.

jon2 · 2021-02-25T16:38:29.313Z

Been there

marcosandrepennacout:

If you´re not from bubble, they should consider contracts you!

Been there with this exact issue myself. If you spend enough time beating your head against the wall, eventually you may also become an ‘expert’ (I use that term for myself very loosely)

marcosandrepennacout · 2021-03-01T15:09:59.993Z

Now I have new issues… Json Machine is not easy to use at the same time it is…
1- I canot acess data inside [ ] . I tried all options … i could read the inside [] values in a Text, but could not acess it by readJson. Anyone can help me with this?
Another question is:
2- can I use a json data out of the User DB? I tryed to make another one, but it seens i can readJson only in User DB, and, in a field called “json”, just like in example sample… I think this should be something I missed because there´s not any logic in mantain such limits!
Any help should be highly apreciated! Thanks in advance.

marcosandrepennacout · 2021-03-03T17:19:47.429Z

Strage things, as always with me!
I can get “members” fields, but I cannot acess the inside members list of jsons! Tryed thousands of configs.
Anyone knows how to get only one field inside another? I did it like the example and doesn´t works… Aff . …

marcosandrepennacout · 2021-03-07T20:08:10.718Z

As soon no awsers has been given to me, I returned after smashing my head in the screen until it works!
To take values within cells that are inside cells you need to go deeper and deeper into the hierarchy, obviously. But doing this isn’t as easy as it seems… so I’m going to play my workflow.

At each step in the hierarchy we must create a Group, or a Repeating Group to select the search space. So within this group we insert a ReadJson.Having taken the first level, we took another group or repeating group inside the first one.

Going into detail my assembly was like this:
1st group with User Type=User, Data Source= current User.
2nd within this Group we created a Repeating Group that will receive the ReadJson’s “Json variable from the beginning of the hierarchy” +get listOfJsonstexts" and a text with “current cell text” to get the value taken back.
3nd As I select the indexes that should be searched for by a Dropdown, I added within the latter a Repeating Group, type of content=text, and data source=Multidropdown Value’s.
4nd Still within this Repeating Group I put a readJson with key=current cell and json text=readJson of this same Repeating group + get list of Json texts.
5nd A Text will read this readJson value to draw it on the screen. A Text will read this readJson value to draw it on the screen.
6nd At each step in the hierarchy we add a Repeating group within the other with a readJson for each and a Text returning the d oReadJson values of the cell. At each step in the hierarchy we add a Repeating group within the other with a readJson for each and a Text returning the ReadJson values of the cell At each step in the hierarchy we add a Repeating group within the other with a readJson for each and a Text returning the d oReadJson values of the current cell

I hope this could help the comunitty, if yes, leave a Heart!

ezhang · 2021-03-18T15:39:39.423Z

Hi @jon2 ,

Thanks for the awesome plugin!

I’m trying to use the plugin to read something like this:
[{“Sales":"ezhangtest@gmail.com”,“Monthly Sale”:100000,“Month”:6},{“Sales":"ezhang@test.com”,“Monthly Sale”:200000,“Month”:4}]
In your example app, there is already a key “member” for the nested JSON text for the readjson element. Can you please provide some insights of how to read the JSON text above without a key?

Thanks,
Evan

jon2 · 2021-03-18T19:54:32.796Z

ezhang:

Can you please provide some insights of how to read the JSON text above without a key?

JSON Machine uses text which defines an object in Javascript. What you’ve got here is text which defines an array and JSON machine cannot work with that natively. You could try merging your array’s text with the necessary text to convert the array into an object.

something like:

{ "examplearraykey" : + ** your array text ** + }

which should produce this as the output:
{ "examplearraykey" : [{“Sales":"ezhangtest@gmail.com”,“Monthly Sale”:100000,“Month”:6},{“Sales":"ezhang@test.com”,“Monthly Sale”:200000,“Month”:4}] }

This has now been formatted as the proper JSON object, which can be worked on with JSON machine, just target ‘examplearraykey’.

ezhang · 2021-03-18T20:07:44.652Z

Hi @jon2

Thank you so much for your suggestion! That makes sense!

Evan

florian.briand · 2021-04-28T21:07:40.179Z

Hey @jon2 !

Thanks for the plugin, it is really good ! Except that I’m encountering a bug in the Update action, on the JSON_arr field which is expected as json_arr in the code
Could you fix it ?

florian.briand · 2021-04-28T21:12:26.989Z

And there is also a bug in the parseArrayOfJSONs function, where you are using for (let jsonItem in arr) instead of for (let jsonItem of arr) (so you’re iterating on indexes instead of array’s items themselves )

jon2 · 2021-04-28T21:58:13.226Z

Hi Florian,

Nice catch. I’m thinking I don’t code enough in ES5 to use that somewhat-confusing nomenclature reliably I’m surprised this hasn’t been mentioned before!

I’ll look at it.

jon2 · 2021-04-29T17:43:20.368Z

I’ve pushed a fix. Take a look and let me know if you have any problems

florian.briand · 2021-05-01T11:00:49.172Z

It seems ok, thanks !

I’ve published a complementary plugin, allowing to use JSONata on a JSON ! Feel free to enjoy it

[New Plugin] Simple JSONata : easily query and transform your JSON Showcase

This plugin allow to use JSONata syntax to query or transform a JSON. I made it to perform operations on complex data structures. For example, if I have list of values (from inputs in Repeating Group for example), I use JSON Machine to store all the data, then perform JSONata query/transformation to, for example, sum the values. More examples are available on the demo page. It is very usefull combined with other JSON plugins like JSON Machine. This plugin offers a better stability and a simp…

florian.briand · 2021-05-01T11:43:20.841Z

I’ve found another bug, in the readJSON operator, in the function getValue(key) function declaration.

The following “if / else” (used when you have a key containing some . separators) is not working to get “non object” results.

		if (key.split('.').length > 1){
			let foundObj = obj;
			for (let thisKey of key.split('.')){
				if (typeof foundObj[thisKey] == 'object'){
					foundObj = foundObj[thisKey]
				}
				else {
					return foundObj;
				}
			}
			return foundObj;
		}

Indeed, if the last item targeted by the key is not an object (so if typeof foundObj[thisKey] == 'object' is false), it’s the foundObj which is returned (which is the object from the previous iteration) instead of foundObj[thisKey].

So, in fact, I think you should do a return foundObj[thisKey]; here. (I think the return is here to interrupt the loop if you reached a non-object point ?).

jon2 · 2021-05-01T12:23:28.365Z

Are you experiencing an unexpected behavior at runtime?

florian.briand · 2021-05-01T13:17:38.171Z

Yes, for example :

Input JSON :

{
  "firstLevel": {
    "secondLevel": "value"
  }
}

Key : firstLevel.secondLevel

Expected result :

"value"

Current result :

{
  "secondLevel": "value"
}

basel.3adel · 2021-08-21T21:40:18.029Z

Great plugin!

I’m facing a similar issue because of the dot thing (.) In the key itself

I have an key called ‘topics.topic-level1’ that the plugin doesn’t recognize as a key or return any values … this an external service and I don’t have control of the key naming conviction. Tried to add " or ’ but didn’t work as well.

Any solution for that?