Data in VDS as API endpoint in JSON format

1

Hi,
I have created a VDS ( say v1 ) under space ( say s1 ) consisting of a view which has n fields from a database table ( from Hive ).
How can I get an API endpoint URL that will have the data from v1 in JSON format?
I intend to use the endpoint URL as the data source for downstream reporting tool.
Thanks

eg.
sample data
c1 c2
k1 val1
k2 val2

When I go to the endpoint URL, it should give me -
[
{c1:k1,c2:val1}
,{c1:k2,c2:val2}
]

2

You can use the SQL endpoint to submit a SELECT * FROM v1; or any SQL query.
You can use the Jobs endpoint to retrieve the results of that query run.

1 Like
3

@isha - thank you so much for your response.

Following the documentations you’ve provided, I could execute the REST API call on the SQL endpoint ( which gave me the Job ID ) and passed the Job ID in the 2nd API call on the Job results endpoint successfully.

However, since I need to configure the REST API as a data source for downstream reporting tool,
is there a way I can use just one single API call ( ie combine the 2 calls of getting the Job ID and then passing the Job ID to get the results into one ) ?

Thanks