Superset provides the following endpoint for slice (charts) data,
@expose('/slice_json/<slice_id>')
def slice_json(self, slice_id):
form_data, slc = self.get_form_data(slice_id, use_slice_data=True)
datasource_type = slc.datasource.type
datasource_id = slc.datasource.id
return self.generate_json(datasource_type=datasource_type, datasource_id=datasource_id, form_data=form_data)which takes in a sliceID as an argument and returns a json object for the given chart. The json returned contains a lot of information such as the data in the slice, the query used to create it, the filters available in the slice and the datasource.
In order to get authorization for this access, since authentication is done using openlmis OAuth, we can a user's access token. The request would be
curl -s -L --cookie-jar "cookies.txt" -H "custon_api_token:<access_token>" "https://superset.ona.io/oauth-authorized/openlmis"
The above request sends a user's access token to superset and in return it gets a session cookie which is stored in the cookies.txt file. The cookie can then be used to get data from superset like
curl -s -L -b "cookies.txt" "http://superset.ona.io/superset/slice_json/<slide-id>"
The user would have to have the right role/permissions in order to receive the data that is being accessed.