Create json File

[Clint]

I'm sorry for what is probably a simple question. 

If I want to use data from a view (ideally - or a table if I had to), making it accessible to a javascript charting library (like d3.js) , how do I export it (or make it real-time accessible) as a json file without jumping through a bunch of hoops? 

For some reason I'm not making the connection... 

Thanks so much!

Clint

[Vitalikssssss]

Hi @Clint,

You cannot export table/view from Caspio Bridge in JSON format.

You can use Caspio REST API in order to get records from a table/view in JSON format.

Hope this helps.

Regards,

vitalikssssss

 

[Clint]

Thanks vitalikssssss  -

I haven't done anything with REST before, and am stuck with how to begin implementing it.

Do you know if any starter template/files that Caspio may have for those of us learning how to A: use REST and B: use REST to get records in JSON.

I've gone through the help documentation and for some reason get lost.
The problem when your lost is you don't know which trail to take to get back on track. I feel like I'm missing the "you are here" sign on the map.

[LunaLovegood]

Hi @Clint ,

 

To start using REST API, you should create a Web Service Profile first in your Caspio Bridge account.

If you're using Chrome, you may use Advanced REST Client (an add-on).

If you're comfy with Firefox, then you may use this .

I attached a file that may help you with this.

 

JSONAPI.docx

[VA123]

On 6/27/2018 at 6:50 AM, Vitalikssssss said:

Hi @Clint,

You cannot export table/view from Caspio Bridge in JSON format.

You can use Caspio REST API in order to get records from a table/view in JSON format.

Hope this helps.

Regards,

vitalikssssss

 

Can you do this in real time or you have to send requests every hour through the REST API? I would like to get real time updates exports from Caspio via some way or form. I know you can do this with Zapier, though Zapier is not HIPAA compliant.