We need to extract Existing Data out of Apptio R12 Data sources, through Programmatic approach. E.g. May be API calls. Please suggest something probably through small example. 

@Jenny Goodwin @Ericka Norman @Jesse Sharp

Have you tried: API tutorial: Download and upload v.12 Cost Transparency table using Postman tool 

this Tutorial should get you started. You can use any programming language that supports http requests.

regards

Sanjay

Great article thanks. I had the same question and this is exactly the answer I was looking for!

@Babu Hussainsab Mehrunnesa, if you know how to write Powershell scripts, you can easily extract the data. Use the Show API menu from the tables you want to extract to get the path of the tables. Also, the data needs to be extracted from Staging and show make sure the calculations are complete in Staging before you execute the Powershell scripts.

@Babu Hussainsab Mehrunnesa We do a LOT of data extraction and in addition to Tony’s recommendation, I would say the better approach is to have use datalink API to run the connectors to put the data and put it in a location. So you will use datalink api to control connectors.

i personally prefer python - but you can most definitely use power shell curl command. Search the knowledge base for examples.

@Tony Wong, how does the Powershell script connect to the Apptio instance.  Do you have an account set up to allow this access?

Hi @Jeffrey Smith,

the tutorial in my first response takes you through the setup required in front door.

you can also look at https://tbmcouncil.jiveon.com/docs/DOC-7836?commentID=10406#comment-10406 

@Sanjay Valiyaveettil is correct. Basically anyone with a Apptio login can be setup. In summary, in the Access Administration setup area, Click on the "CreateApiKey" and follow the instructions as outlined in the article Sanjay referred to.

Hi tony or anyone have you pulled data from the dev space?  is that possible using the urls?  

@Rutvik Rana, you cannot use Datalink API to pull from DEV space because it is real time calculation. If it is only a few files you need, then just export to TSV in the DEV space. Otherwise, you need to check in and wait until Stage is fully calculated. Also, bear in mind that the Build # for Stage has to be different than Production (if you have a Production site setup); otherwise the extract will fail. In other words, try not to promote to Production before you finish extracting the tables.