How to access synapse serverless sql pool data using .net REST API
Jaydeep Suryawanshi
26
Reputation points
Hi Team,
I have created azure cosmos database with analytical store enabled (through azure synapse link).
I am using built in sererless sql pool, I have created couple of views to access the data from analytical store. I want to access these view through using .net REST api.
I followed the answer provided here, but when I am making REST api call I am getting bad(400) request error.
Access Token Request details:
- GET Request URL - https://login.microsoftonline.com/{tenantId}/oauth2/v2.0/token
- Body:
grant_type:client_credentials
client_id:******
client_secret:*****
scope:https://graph.microsoft.com/.default
Once I get then access token then I am using it next request as below.
POST Request URL : https://{workspace-name}-ondemand.sql.azuresynapse.net/query
Bearer Auth - Access token
Body -
{
"sql":"SELECT * FROM {ViewName}"
}
Can someone help to get this resolved pls?
Thanks
Sign in to answer