[🌟 New Features: Ultra-Deep Drill] JSON Assistant Plugin: Your Solution to Complex JSON & API Data in Bubble

Thank you for your kind words! :raised_hands:

We are always glad to hear that our support is appreciated. Your suggestions for features are valuable in helping us to continuously improve and meet the needs of our users.

Keep them coming

Exciting Updates to JSON Assistance - New Feature Release

Dear valued users,

We hope this message finds you well.

We are excited to share that we have rolled out some significant enhancements to our JSON Assistance based on your insightful feedback and suggestions. We always believe in the power of collaborative growth, and it is your continuous support and valuable ideas that help us improve.

One of the key features in this new version is the ability to retrieve data in a similar manner as bubble data types. This feature was suggested by @MarkusBoostedApp ,Markus, we thank you for your input! , and we are thrilled to bring this to life.

Here’s how it works:

  1. Create a dummy API.
  2. Add an empty ā€˜GET’ call to it.
  3. By Manually enter API response, insert a sample of your JSON and set each field’s data type.
  4. In the Extractor Element, there’s a new field where you can select the ā€˜GET’ call that you’ve built as a data type.
  5. You can access the converted data by the element’s state, Converted Data List.

We believe this new feature will greatly enhance your experience with JSON Assistance, making it more flexible and user-friendly.

We want to extend our gratitude to all of you, particularly to @MarkusBoostedApp who brought this innovative idea to our attention. Your continuous feedback, suggestions, and engagement fuel our growth and evolution.

Please try out this new feature and let us know how it’s working for you. Your feedback is crucial for us to continue improving and evolving.

Thank you once again for your unwavering support and contributions to JSON Assistance.

Best regards,
Mehrdad


We were inspired to add this feature in part by the excellent work done on the JSON to Bubble / Things plugin by Mintflow.
A special thanks to @lottemint.md for devising the method we’ve outlined above. Check out the full post here.

4 Likes

:clapper: Tutorial: Quiet Quest Series

JSON to Bubble Data Type Conversion with JSON Assistant

1 Like

Can I use this Plugin to modify json items? @NoCodeDataArtisan

I want to save entire lists of tasks in a json format: task name, completed (boolean), etc… and turn this into a repeating group my user can modify.

Is this possible with your plugin?

1 Like

Hello @myjourney,

Thank you so much for getting in touch with us!

I wanted to let you know that currently, our plugin doesn’t directly support this feature. But, the good news is, we’re actively working on enhancing it to facilitate easier JSON manipulation.

We’re excited about our upcoming update, which aims to simplify editing and even manually creating JSON.

We’d love to hear more about your specific needs. This way, we can make sure that our new version meets them perfectly.

Looking forward to your thoughts!

2 Likes

This would be truly amazing.

I think a lot of people would benefit from this feature. Currently, each task item is saved to the Bubble database with all its relevant information (status, category, task text, description). Modifying a task (check it off), is relatively slow.

Additionally, exporting the entire list of tasks to a third party, like Open AI, doesn’t work well.

I need to generate a Repeating Group with all the tasks, that allows me to populate a nice, neat list, grouped by category. Every task of course, has a status (checked, unchecked), etc.

Does this make sense? Do you have an ETA of when you’d have this feature? My wallet is ready to pay!

Here’s a sample json:


{"list":{
    "list_name": "Stuff do to at home",
    "tasks": [
        {
            "task_name": "Clean out the closet",
            "completed": false,
            "deleted": false,
            "index": 1,
            "category": "Personal"
        },
        {
            "task_name": "Organize the garage",
            "completed": true,
            "deleted": false,
            "index": 2,
            "category": "Personal"
        },
        {
            "task_name": "Prepare tax documents",
            "completed": false,
            "deleted": true,
            "index": 3,
            "category": "Personal"
        },
        {
            "task_name": "Plan the weekend trip",
            "completed": true,
            "deleted": false,
            "index": 4,
            "category": "Work"
        },
        {
            "task_name": "Write thank you notes",
            "completed": false,
            "deleted": false,
            "index": 5,
            "category": "Work"
        },
        {
            "task_name": "Schedule doctor's appointment",
            "completed": true,
            "deleted": true,
            "index": 6,
            "category": "Personal"
        },
        {
            "task_name": "Renew car insurance",
            "completed": false,
            "deleted": false,
            "index": 7,
            "category": "Home"
        },
        {
            "task_name": "Update resume",
            "completed": true,
            "deleted": false,
            "index": 8,
            "category": "Personal"
        },
        {
            "task_name": "Read a book",
            "completed": false,
            "deleted": true,
            "index": 9,
            "category": "Home"
        },
        {
            "task_name": "Plan the birthday party",
            "completed": true,
            "deleted": false,
            "index": 10,
            "category": "Personal"
        }
    ]}
}
1 Like

We’re glad to hear that you find this feature helpful. We appreciate your feedback.

I’m sorry, but I’m not clear on what kind of changes you want to make. Could you please send me a screenshot of the app database? And explain how the data flows in steps.

Maybe there’s a way to solve your problem with the existing features.

I’m showing you an example of the kind of JSON I’d like to manipulate with a plugin. For example, change a specific task from ā€œcompletedā€ from false to true, or the other way around.

I don’t yet have anything implemented yet as it doesn’t seem like any plugins can do this. Am I wrong?

1 Like

Hey there,

I have a great news for you, I will release the new version of plugin soon and there is a new element that is incredibly limitless.

The element has been implemented to plugin and works well with any JSON. I am currently working on its documentation and trying to make it user friendly.

2 Likes

This sounds very exciting! Can’t wait!

Happy to beta test if you need it!

1 Like

Hey, I have this API Call (Uploaded below) and I want to use your plugin to extract that data and use it in text elements. How can I do it?

1 Like

Hey there,

Sorry for late response, actually we are working on some new features and the new version will be released in a few hours.

With the new version, there is no limit on working with JSON, however it seems you can achieve your desired result with current version.

3 Likes

That’s great! I’m excited to see the new version. Is there a way that you can assist me with that need of exposing the data from API (even the deeper ones) in the text elements in my page? I’m trying but I haven’t achieve nothing. :frowning:

1 Like

Holding my breath for this release!

1 Like

Hey @myjourney

I’m sorry for not informing you earlier, but we released a new version of the plugin yesterday.

By updating it, you’ll gain access to two new elements. Detailed explanations and examples for each element can be found in their fields documentation.

Additionally, we’ve added a new tab in the demo specifically for these elements. We understand that these features might be complex, so we’ve included a range of examples to demonstrate how they function.

1 Like

Sure,

You can explain what you exactly want to achieve, and I will guide you through the steps of utilizing the new element to solve your problem.

Also, it can be helpful for others who have similar challenges.

:bell:
New Version
Exciting Update for JSON Assistant Users!

Introducing JSONata and JSONata Minor Elements

Hello, Bubble Community!

We’re thrilled to announce two powerful new additions to our JSON Assistant plugin: JSONata and JSONata Minor. These elements bring the robust capabilities of JSONata to your Bubble apps, empowering you to tackle even the most complex data scenarios.

Simplifying the Complex JSONata is a powerful query and transformation language for JSON data. It allows you to filter, map, reduce, and transform your data dynamically. Think of it as a super-charged calculator for your JSON data, making complex data handling a breeze.

What’s New?

  • JSONata: This is our base element, designed for handling intricate JSON data transformations and extraction. It’s a bit complex but unlocks limitless possibilities!

  • JSONata Minor: Tailored for when you need multiple elements, like placing them in a repeating group. It’s the compact version of the base element, ensuring efficiency without compromising on functionality. And it can easily linked to a base element and use it’s output.


Examples:
Explore our new tab with multiple examples demonstrating these features in action.
JSON Assistant (JSONata Element)

Support:
Stuck or need inspiration? Post your data sample and goals on this forum. We’ll guide you with solutions ASAP!

As always, we’re here to support and grow with our amazing community.

2 Likes

I have a really long API response, which contains lots of nested data and list, that I need to expose on the page using text elements.

I can’t post it read because it exceeds the character limits, but I’ll post a snippet, so I can see.

{
  "Juridico": {
    "cpf": "09862138882",
    "nome": "JOAO PAPP JUNIOR",
    "rg": "18044470",
    "orgaoEmissor": null,
    "ufEmissao": "SP",
    "dataEmissao": null,
    "nomeMae": "NEIDE ARRIATE PAPP",
    "nomePai": null,
    "sexo": "M",
    "dataNascimento": "1969-05-15",
    "escolaridade": "Superior completo",
    "emails": [
      "pappjr@gmail.com",
      "pappjr@hotmail.com",
      "jpapp@uol.com.br",
      "joaopapp@yahoo.com"
    ],
    "participacoes": [
      {
        "cnpj": "35717259000132",
        "razaoSocial": "SUCESU SP ASSOCIACAO DE USUARIOS DE INFORMATICA E TELECOMUNICACOES DO ESTADO DE SAO PAULO",
        "cargo": "Diretor",
        "participacao": null,
        "dataEntrada": "2019-11-05"
      },
      {
        "cnpj": "46328295000120",
        "razaoSocial": "TUG BIG DATA INFORMACAO E TECNOLOGIA LTDA",
        "cargo": "Socio-Administrador",
        "participacao": null,
        "dataEntrada": "2022-05-10"
      }
    ],
    "rendaPresumida": {
      "faixaRenda": "A (acima de 20 SM)",
      "origemRenda": "EMPREGADO"
    },
    "enderecos": [
      {
        "tipoLogradouro": "R",
        "logradouro": "EMILIO WINTHER",
        "numero": "620",
        "complemento": "BL B AP 13",
        "bairro": "JD DAS NACOES",
        "cidade": "TAUBATE",
        "uf": "SP",
        "cep": "12030000"
      }
    ],
    "telefones": [
      {
        "tipo": "MOVEL",
        "numero": "12981150147"
      }
    ],
    "situacaoRfb": {
      "anoObito": "",
      "dataConsulta": "2021-08-27T00:00:00",
      "situacao": "REGULAR"
    }
  },
1 Like

Thank you for sharing your question, Could you please explain what you mean by exposing them by text elements?

Do you need extract values of specific keys? Could you please provide some examples of the results?

Yes, you’ve got it right. I need to extract the values from specific keys. For instance, I need to use the value of the ā€˜cpf’ key, as well as ā€˜nome’, ā€˜rg’, and so on. To do this, I first need to access the ā€˜Juridico’ key. There are other keys that are more complex, like ā€˜participacoes’, which is a list containing other keys within each item.

1 Like