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.
You could also maybe use a file upload type component to get your JSON into your app!
This helps a lot. Thanks a lot guys.