Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Open PermID /
avatar image
Question by mayur.b · May 09, 2018 at 06:40 AM · permidrdfttldump

How to read TTL/n-triple dumps?

I got organisations ttl file from https://permid.org/download. While trying to parse it with RDFLib, I get parsing errors. I tried it with n-triple file as well.
How do I read this file? I want to convert this to csv and I'm open to any programming language to do so.
Thanks

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · May 10, 2018 at 11:07 PM

I found one solution to convert the ttl to csv in stack overflow. It uses arq command in Apache Jena.

To convert to CSV, I have to create a SPARQL query.

For example, the query for converting OpenPermID-bulk-assetClass-20180506_071050.ttl to CSV looks like:

The above query is saved in assetQuery.rq.

Then, run the arq tool.

arq --data Open
PermID-bulk-assetClass-20180506_071050.ttl --query assetQuery.rq --results csv > asset.csv

The content in asset.csv file is:


asset.png (44.2 KiB)
assetquery.png (18.7 KiB)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ · May 10, 2018 at 11:11 PM 0
Share

assetqueryrq.txt

assetqueryrq.txt (488 B)

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

PermID atom feed now has at most 500 entries. not enough to cover time since last bulk file

Incorrect format for links in PermId RSS feed

How to get all the info on the PermID page via the lookup API

Trying to use permid file match and receive error Failed to resolve API Key variable request.header.X-AG-Access-Token

processing organization bulk download using node js

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges