Hi everyone,
I have a necessity of storing my Bubble database online (doesn’t really matter where) and reading the CSV files from google cloud functions.
Does anyone know how to do this? I know I will probably need to use APIs but I would like more concrete help.
Thanks in advance!
You might consider storing it on Bubble 
Likely.
You can check out some nocode/lowcode databases like backendless
Thank you really much for your reply!
Another option I am considering is using the Bubble Data API, but I am having some authorization issues. Have you ever used it?
Once you enabled the Data API you have to go to Privacy rules and enable “Create via API” (or Modify and Delete) for the datatypes you want.
@tylerboodman thank you really much! That is a great insight.
I have managed to retrieve data with the Data API, but it seems I cannot access certain fields like the user unique_id or the email (which is a built-in field). It probably is a privacy issue, but when I go on the privacy settings those fields don’t show at all.
Do you have any idea how to solve it?
(There is no bubble workflow for it, I am just doing API calls from a python console for now)
I just did a Data API call to my test app and it returns everything including email and _id (unique id). As long as you generated an API key in your app settings your Google Cloud should have full access. Works with and without a privacy setting on the datatype…
GET [appurl]/version-test/api/1.1/obj/user
responds:
{
"response": {
"cursor": 0,
"results": [
{
"Created Date": "2022-11-24T22:50:38.213Z",
"Modified Date": "2023-05-27T04:52:21.010Z",
"user_signed_up": true,
"authentication": {
"email": {
"email": "[email protected]",
"email_confirmed": null
}
},
"Name-dbv": "Steve",
"Company-dbv": "1685163128552x119955685672303860",
"_id": "1669330238213x822383741817062900"
}
],
"count": 1,
"remaining": 0
}
}
Oh , I see you’re right about the unique ID. I didn’t see it because it was strangely saved as “_id”.
Anyway, thank you really much. You definitely put me on the right path.
Even if we can consider the topic solved. I would like to ask another thing. Do you know how can I send the current user info in the API call together with the other data?
I tried including it in the JSON body of the API call but nothing seems to change.
Not sure what you mean, what would be Current User if your external service is just accessing as an admin?
Yeah, sorry let me explain further. I want to apply an algorithm hosted on the cloud on both the updated database and on the Current User’s info.
To make it simple let’s say when “Button A” is clicked, I would like those data to be sent. Is there any way to capture the user’s info whom is clicking on the button?
If you mean clicking the button on your Bubble app, and your making sending a request to your external service using the API Connector, then yes you can add a parameter and send the Current User's unique id along with the api call.
Yes, that’s exactly what I am trying to do.
This is the json body: { “Current User”:<Current User’s unique id>}
Yep that would work, but when setting it up in your API connector you would just do <currentuser> or some arbitrary placeholder name, unchecked Private, then on the client side you can dynmically fill in the parameter currentuser with Current user's unique id
I am having some issues in understanding if it is working or not. Let me add some more context.
This is the scheduled api workflow
This is the action in it:
And this is the button workflow:
API connector:
I am both not understanding why in the api gateway it is asking for a text (unique id) and I can’t put the current user info and where I should be able to retrieve the current user’s info in the response.
Do the API Gateway - Test Google action directly on the button’s workflow, no need for the Schedule API Workflow
I made the changes you suggested, but the API response (the data I get) is still the same, it seems to be no trace of the Current User. I will try to make it work, I’ll let you know in case of success.
Thank you really much!
