JSON file as Resource

How can I use a JSON file as data source for the prototype app that I am building? I don't see the option of JSON in the list of resource types.

The JSON can be queried using Query JSON with SQL as the data source.

Thanks ScottR. Where exactly do I store my JSON then? Copy pasting the content in the data section gives an error.

Depends on where you are getting it from.
You can store it in a temp state variable and then query that temp state variable.

For the first prototype I just have a local json file that I want to use. Later I'll connect the retool app to a DynamoDB.

OK so create a temp state variable and store it there for now. See docs

You could also maybe use a file upload type component to get your JSON into your app!

https://retool.com/components/file-input

https://retool.com/components/file-button

This helps a lot. Thanks a lot guys. :slight_smile: