I want to make a complex query that I was unable to do by querying a collecting from within Flutterflow.
So I created a custom function and deployed it on Firebase.
Then I set up the API call in Flutterflow.
Now where I am confused is, how do I map datatypes for Document References? When I try to map the results to a List component parameters, I am unable to map them.
Here is my custom function code:
const functions = require("firebase-functions");
const admin = require("firebase-admin");
admin.initializeApp();
exports.fetchFilteredDocuments = functions.https.onRequest(async (req, res) => {
const userId = req.query.userId;
if (!userId) {
return res.status(400).send("User ID is required");
}
const firestore = admin.firestore();
const userDoc = await firestore.collection("users").doc(userId).get();
const following = userDoc.get("following") || [];
const querySnapshot = await firestore.collection("poll")
.where("userID", "in", following)
.get();
const filteredDocuments = querySnapshot.docs
.filter((doc) => {
const votedBy = doc.get("votedBy") || [];
return !votedBy.includes(userId);
})
.map((doc) => ({
id: doc.id, // Document ID (reference)
path: doc.ref.path, // Document path (another way to get a reference)
...doc.data(),
}));
return res.json({documents: filteredDocuments});
});In Flutterflow, I added the API call:
But when I run the test response, I get a list of items.
For example, both the "Title" and "image1Votes" are "String" and "Int" respectively, but the returned values are List.
Which means that when I try to map them to the List component parameters, I am not able to do so. Eg. here you can see that I need a "String" but I an getting a "List":
Can idea what I am doing wrong here?