Left Menu Right Menu

This document shows how to retrieve a set of search results from Primo using the PNX API, and convert the raw data to a CSV file.


Created By: Blake Galbreath, WSU

Skill set requirements: API; PNX;


Developers Network PNX API:

https://developers.exlibrisgroup.com/primo/apis/webservices/rest/pnxs


Generic url to pull set of records from Primo:

https://api-na.hosted.exlibrisgroup.com/primo/v1/pnxs?q=any,contains,book&apikey=yourapikey


Example of actual url to pull a set of records from Primo:

https://api-na.hosted.exlibrisgroup.com/primo/v1/pnxs?limit=200&vid=[YOURVID]&scope=[YOURSCOPE]&q=any,contains,dog%20cat%20mouse&apikey=[yourAPlkey]



Raw JSON - She's a Beaut!

json_raw2.PNG



File > Save As ‘demo.json’ (however you save from your browser).


For example:

Chrome > 3 Bars > More Tools > Save page as…


Convert JSON to CSV website

http://www.convertcsv.com/json-to-csv.htm


Step 1 - Upload File

json2csv_web1.PNG

Step 2 - Convert to CSV

json2csv_web2.PNG


Step 3 - Look at Prettier Data

json2csv_web3.PNG


Step 4 - Download your data and do something useful with it!


Notes:

Requires you to have API key and vid and scope codes from PBO