Uploading Json data file

Need help Database
1

So I’m trying to upload data using a JSON data file. ( .json file)

Got a few questions:

  1. How do I extract the data from the file?
  2. Is it possible to refer directly to the file data when the file is uploaded?
  3. Is there a way to convert the JSON data file into some other format on bubble itself? ( Cause cant make my users go to another site for this)
1 Like
2

I’d suggest to use Javascript to achieve points 1 and 3. You can do so using the Toolbox plugin

1 Like
3

Or, depending on your use case, simple convert the file to csv (e.g., JSON to CSV Converter)

1 Like
4

Hey @yashch1998 - how consistent is the data from the file?

1 - You can use a plugin or set up an API data type within Bubble (if the json is consistent) - see step 2
2 - Yes, once uploaded you can GET the file url to return the JSON in a usable way (using Bubble’s API Connector)
3 - What would you like to convert this to? Once you have a method to parse the data (step 1&2), you can create Bubble things, csv files or anything else you would like.

Hope that helps

1 Like
5

Could you please explain the 2nd point in more detail?
As I didn’t know how to make the GET call using the dynamic URL ( Since each time the json file is uploaded, a new URL is returned)