News and news metadata

BelianK

Dear Support,

I’d like to ask your help with Refinitiv Codebook. There is a smaple Python code in the Workspace application that can exctract news but the code stoped working since a few days. This sample code was provided by Refinitiv and I didn’t make any modification in it but I’d like to use it. I attached screenshot where the issue occures it seems the storyText column is empty and Python is not able to join it with the storyID.

Jirapongse

@BelianK

Thank you for reaching out to us.

Please change the code to this one:

baseurl = "/data/news/v1/stories/"

fullcodelist = pd.DataFrame()

compNews['storyText'] = str()

compNews['q_codes'] = str()

compNews['pIDs_mentioned'] = str()

compNews['RICs_mentioned'] = str()

compNews['urgency'] = str()


for i, uri in enumerate(compNews['storyId']):

    request_definition = rd.delivery.endpoint_request.Definition(

        url = baseurl + uri,

        method = rd.delivery.endpoint_request.RequestMethod.GET

    )

    response = request_definition.get_data()

    time.sleep(0.1)

    rawr = response.data.raw

    if 'newsItem' in rawr.keys():
        compNews['storyText'][i] = rawr['newsItem']['contentSet']['inlineData'][0]['$']

        topics = rawr['newsItem']['contentMeta']['subject']

        rics = [x for x in rawr['newsItem']['assert'] if x['_qcode'].startswith("R:")]

        compNews['q_codes'][i] = [d['_qcode'] for d in topics]

        compNews['pIDs_mentioned'][i] = [x for x in compNews['q_codes'][i] if x.startswith("P:")]

        compNews['RICs_mentioned'][i] = [d['_qcode'] for d in rics] 

        compNews['urgency'] = rawr['newsItem']['contentMeta']['urgency']['$'] # 1 = hot, 3 = regular


compNews