I am trying to get a single calculated value (number) from Tableau's API and upload it to another system which we use to track key initiatives progress. I have tried the 'Query Workbook' API - but that simply returns the Workbook Metadata, not the actual data residing the Workbook. Downloading the Workbook doesn't help either because it's a binary format (plus, I would really like to just work with the API and prefer not parse downloaded files).
Is there any other way to do this? I have looked and can't seem to find a way. A bit new to Tableau so it's possible that I have missed obvious options.