question

Upvote
Accepted
966 11 21 26

How can we convert 1000 PermIDs into rics?

What is the API to use?

What is the cost?

permid-apiintelligent-tagging-apiopen-permid-api
icon clock
10 |1500

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

Not supported by DSS "Symbol Cross Reference", TRTH EBD files, nor PermID.org.

Is there a way to programatically convert PermID to any other identifier?

A fast way to convert them in Python is:


If you have a dataframe with PermIDs then you can extract the column for the PermIDs with:

df['Name Of The Column']

and follow the principle below:

### Extract the PermID from dataframe and convert it into a list of strings because ek.get_data takes in strings

ls_PermID = list(df['ame Of The Column'].astype('str'))


### Convert PermID to RIC with ek.get_data

ls_RIC, err = ek.get_data(ls_PermID, 'TR.RIC')


I just want to post this simple and efficient solution here after days of searching how to do it the best way.

1 Answer

· Write an Answer
Upvotes
Accepted
1.2k 23 31 44

Create a "Terms and Conditions" report in DSS with "Issue PermID" and "RIC" fields. This will create a source data set for mapping RIC to PermID. Then you can feed this into your app or create a service that exports it through TREP, etc.


untitled.png (10.8 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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