cancel
Showing results for 
Search instead for 
Did you mean: 

How to export the filenames in the Datasets Library to an Excel sheet ?

Highlighted
Blue LED
I need an excel file with the Filenames and versions in a particular tenant.
How to do so, rather than manually verifying it so ?
Labels (1)
0 Kudos
5 Replies
Highlighted
Linear Actuator
HI there, can you please clarify your question a bit more:
--do you want to export your Paxata AnswerSets, in Excel format, *and* also include the dataset version number from which the AnswerSet was produced?
or
--do you want to export *all* of your dataset names from your Paxata Library to an Excel spreadsheet so that you have an Excel list of all of your Pax datasets?

If you can please provide an example of what you are trying to do, that would be ideal :)
0 Kudos
Highlighted
NiCd Battery

Hi @PramodSR,

This can be done using our REST API. You can use curl or other tools to send a GET request to /rest/library/data. This will return the information you are looking for and more. Please visit our documentation portal for more information: https://paxata.atlassian.net/wiki/spaces/PaxDocs/overview

0 Kudos
Highlighted
Linear Actuator

@PramodSR
It sounds like you're trying to download metadata about the datasets that exist in the Data Library.  Our export features are built to facilitate export of the actual data to a variety of formats and destinations. There is no UI feature that allows you to do that.

However, the Paxata REST API does support these type of metadata exports.

Create a REST API Token:

Execute a GET request against the "/library/data" REST endpoint

Request URL:
https://<hostname>:<port>/rest/library/data?pretty=true&state=DONE&return=name,dataFileId,version 

  • state=DONE:  return only datasets that have completed import. Remove this to receive all datasets
  • return=<comma separated list>: the fields that you want to retrieve.  I've provided the 3 that you'll likely want, but there are many more that you could specify ("userName" and "createTime" for example)
  • Results are returned in Tab delimited format

Use a Terminal / Command Prompt / Shell: 

  • curl -sS -f -u ":<token>" -X GET "https://<hostname>:<port>/rest/library/data?state=DONE&return=name,dataFileId,version" > PaxataLibraryDatasets.tab
  • Open file in Excel. 

Use PostMan:

  • Download and install Postman from https://www.getpostman.com/downloads/
  • Create a new GET request for the URL
  • Under Authorization, Select Basic Auth and place your REST Token in the Password field
  • Click "Send"
  • When execution is complete, you will receive the results in the lower pane
  • Click "Download" to save the results for 

Image: https://us.v-cdn.net/6030933/uploads/editor/g7/vc7k9bclhksy.png

Thanks,
Bill

0 Kudos
Highlighted
Linear Actuator
Hi All,
I want to download actual data of dataset/answerset programatically. Is there any API to achieve this? If sample curl command is shared then, I will be thankful.

Regards,
Abhijeet
0 Kudos
Highlighted
Linear Actuator
0 Kudos