topic Exporting Master Items using API in App Development

Exporting Master Items using API

Anonymous — Thu, 14 Jun 2018 13:41:29 GMT

Hi everyone,

I am new to using the API and was wondering if it is possible to export a master items list created in any given application to an excel document (or any document for that matter). I have an app that has a number of master items (both measures and dimensions) and I need to document all its information and I thought there must be an easier way then to copy and paste everything. If someone could point me in the right direction or supply me with the code that would be awesome.

Thanks again everyone.

Re: Exporting Master Items using API

Anonymous — Thu, 14 Jun 2018 15:14:13 GMT

also I forgot to mention that if anyone knows a different way to export a list of the master items and all the information pertaining to each item that doesn't involve the API that works too!

Re: Exporting Master Items using API

Prashant_Naik — Wed, 20 Jun 2018 13:31:53 GMT

Hi Joshua,

you can loop with the master item data and store it and write that data in excel

please follow below link to store the data in xls format

javascript - How to write data into an xls sheet in js - Stack Overflow

Or you can store the data in json format also for this here is the code.

var items=[]; //define an empty array

this.app.getAllInfos().then(res=>{ //get all the info of app

//here you can loop and check which masteritem (dimension/measure) is and store it in json format

items.push(res);

jsonfile.writeFile(Objlist, Items, function (err) {

console.error(err)

})

Regards,

Prashant

Re: Exporting Master Items using API

Anonymous — Wed, 20 Jun 2018 16:02:31 GMT

Thank you Prashant.

After some further exploration the first technique you mentioned I had considered doing. One of my colleagues ended up figuring out a similar technique to your second suggestion and it worked out rather well! Thanks again for your input, much appreciated.

Regards,

Josh

Re: Exporting Master Items using API

tejes — Wed, 03 Jul 2019 07:38:00 GMT

Hi Josh,

Could you please explain the process of exporting dimensions/measures.

Regards,

Tej.