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?

@Neil Shah

Hi. Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Else please post again offering further insight into your question

Thanks

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.