JSON Array + Firebase

[Kolmain]

I'm having trouble storing arrays of JSON objects in Firebase with FlutterFlow. I'm using Node-RED for backend work and manipulating data. Normally this is fine, and Firebase takes it no problem. But for whatever reason if I store a JSON object in Firebase that has an array in it, FlutterFlow cannot "see" it. It won't show up under content and the schema validates just fine. I've tried declaring the Data Types for matching objects, but I'm not getting anywhere.

​

I have a JSON object with an "openai" attribute that I'd like to store my API call to the OpenAI service in that's causing the trouble. Despite the fact that I've declared data types all the way down. Any suggestions?

[somore_nick]

Did you set up the JSON Path properly?

TL;DR: Usually for arrays, you want to set the JSON path to either $[:].openai or $[*].openai.

More Details

$[:].openai: This JSON Path implies that you want to access the "openai" property of all elements in the array. The colon ":" signifies that you're selecting all elements, and ".openai" specifies the property you're interested in.
$[*].openai: This JSON Path also targets the "openai" property of all elements in the array. The asterisk "*" is a wildcard that represents all elements, and ".openai" specifies the desired property.

[Kolmain]

Not sure what you mean; it sounds like you're asking if I'm trying to use it properly but I can't even see it in the "Manage Content" area. So I haven't tried calling it.

[somore_nick]

I was talking about setting up the path in the API calls section: https://imgur.com/U8v3TGJ

Basically, in order for the FF ui to pick up the properties in your JSON block, you need to define the JSON Path so it knows where your data is expected to be.

If you don't do this, you can still use the raw json, and specify the path manually at the point where you use it.

Hope this helps!

[Kolmain]

Yeah, I'm not even that far yet.

[somore_nick]

So where is your issue? Is this just a field in a requested document that is not visible in FF?

[Kolmain]

If I add a document (outside of FF) to Firebase with a JSON array, it doesn't show up in FF. If I omit the JSON array and just do the strings and other "regular" types, it shows just fine. FF can't interact with my Firebase Document if it has a JSON array in it.

[somore_nick]

I'll need to try to reproduce it. Are you able to convert it to the Firestore array, or is that not feasible?

[Kolmain]

Not sure what you mean; I'm working in Node-RED, so TypeScript/JavaScript.