Could you please help , how to get General value 6 and General Value 7 columns for CADISC=, USFFT...

RB5NBVICDORSupport

...ARGET=, CABANK= RIC's using New History Pricing Report?

We are extracting data using New Pricing History report for CADISC=, USFFTARGET=, CABANK= RIC's and not able to find the columns names General Value6 and General value7.Could you please help us to get those column in report.

Jirapongse

@RB5NBVICDORSupport

Sorry for the issue you are facing, let me see if I can help you in resolving this.

I checked and found that the "General Value6" and "General Value7" are available in the Intraday Pricing report template.

 {
            "Code": "IDP.General Value6",
            "Name": "General Value6",
            "Description": "Generic field populated with market- or issue-specific data. The content in this field depends on the instrument type and the market.",
            "FormatType": "Number",
            "FieldGroup": " "
        },
        {
            "Code": "IDP.General Value6 Text",
            "Name": "General Value6 Text",
            "Description": "Generic six-character text fields each describing the value in General Value6.",
            "FormatType": "Text",
            "FieldGroup": " "
        },
        {
            "Code": "IDP.General Value7",
            "Name": "General Value7",
            "Description": "Generic field populated with market- or issue-specific data. The content in this field depends on the instrument type and the market.",
            "FormatType": "Number",
            "FieldGroup": " "
        },
        {
            "Code": "IDP.General Value7 Text",
            "Name": "General Value7 Text",
            "Description": "Generic six-character text fields each describing the value in General Value7.",
            "FormatType": "Text",
            "FieldGroup": " "
        },

You can refer to the Refinitiv DataScope Select Data Content Guide for a list of fields available in each report template.

The request looks like this:

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "General Value6",
            "General Value6 Text",
            "General Value7",
            "General Value7 Text"           

        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "CADISC=",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "USFFTARGET=",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "CABANK=",
                    "IdentifierType": "Ric"
                }
            ],
            "ValidationOptions": {
                "AllowOpenAccessInstruments": true
            },
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "ScalableCurrency": false,
            "OnlyNonEmbargoedData": false
        }
    }
}

The output is:

I hope this will help.