How to Update User Database in Bubble Based on JSON Response?

Lavash · 2024-08-28T15:55:35.985Z

Hi everyone,

I need help with updating a User database in Bubble. I have a JSON response like this:


[
  {
    "user": "ctovla@gmail.com",
    "rating_result": "3.0"
  },
  {
    "user": "frolalala@icloud.com",
    "rating_result": "3.5"
  }
]

I want to update the rating_result field in the User database based on the user (email) provided in the JSON. Is there a plugin or a method in Bubble that can help me achieve this?

Any guidance or examples would be greatly appreciated!
Thank you!

Jici · 2024-08-28T17:51:47.271Z

Schedule API Workflow on a list (list type will be the type returned by the API (json)

Backend WF will have two fields: user (text) and rating (number)

In the WF you will make change to a thing with do a search for user

Lavash · 2024-08-28T18:18:10.032Z

I tried it, but List to run on - doesn’t treat json text as a list

Знімок екрана 2024-08-28 о 21.17.23818×608 42.3 KB

Jici · 2024-08-28T18:19:07.104Z

You are getting the JSON from API Connector?

Lavash · 2024-08-28T18:21:48.201Z

Yeah, but then I process it in Bubble.
I bring it to the input as on the screenshot and from there I want to pass it on…
So I need to do it directly from the API only?

Jici · 2024-08-28T18:24:48.753Z

It’s easier
If you process it, this should be store as text list instead in your DB
so each item will be

  {
    "user": "ctovla@gmail.com",
    "rating_result": "3.0"
  }

And using regex, you could be able to use data inside this JSON object. At this moment, you will keep the data type as text like actually.

Lavash · 2024-08-28T18:50:34.420Z

Use regex

Знімок екрана 2024-08-28 о 21.46.562208×1198 256 KB

Schedule API Workflow set_rating on a list

Знімок екрана 2024-08-28 о 21.47.241536×1466 290 KB

Backend workflow set_rating

Знімок екрана 2024-08-28 о 21.49.231074×1606 96.4 KB

Make changes to User…

Знімок екрана 2024-08-28 о 21.49.441480×772 65.5 KB

I got that right, didn’t I?
Just not all the way through

Jici · 2024-08-28T19:17:32.742Z

No your user and and rating result are not correct in SAWOL
So you are fine with a list of text,
but now in user and rating fields. it should be something like This text:extract with regex (for both user and rating result, just a different regex)

Lavash · 2024-08-28T19:39:42.023Z

Jici:

This text:extract with regex

It seems to work judging by the logs, but alas there are 2 problems
I do not understand why adds judging by the logs only one user and why the database does not save this change, you can see in the log that for example we changed it to 3.0, but in fact in the database in avarage_rating empty… ahem

Знімок екрана 2024-08-28 о 22.36.511360×302 19.6 KB

Знімок екрана 2024-08-28 о 22.36.381486×798 79.5 KB

Знімок екрана 2024-08-28 о 22.37.411166×326 9.07 KB

Знімок екрана 2024-08-28 о 22.38.041504×778 61.9 KB

Lavash · 2024-08-28T19:46:32.671Z

Got it!
The expression was bad, here is the correct one for user and rating_result

(?<=“user”: “)[^”]+
(?<=“rating_result”: “)[^”]+