For a deeper look into our DataScope Select SOAP API, look into:

Overview | Quickstart | Documentation | Downloads | Tutorials

The JSON value could not be converted to System.Int32. Path: $.Contents[8340]['FXIR Scaling Factor'] | LineNumber: 0 | BytePositionInLine: 1516560.

**Request:**

{

"ExtractionRequest": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",

"ContentFieldNames": [

"RIC",

"Trade Date",

"Base Currency Code",

"Currency Code",

"Universal Close Price",

"FXIR Scaling Factor"

],

"IdentifierList": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",

"InstrumentListId": "0x072e374a6d06ba74"

},

"Condition": null

}

}

**Response:**

"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",

"Contents": [

{

"IdentifierType": "ChainRIC",

"Identifier": "AEDX=",

"RIC": "AED=",

"Trade Date": "2020-07-20",

"Base Currency Code": "USD",

"Currency Code": "AED",

"Universal Close Price": 3.6729,

"FXIR Scaling Factor": 1

},

{

"IdentifierType": "ChainRIC",

"Identifier": "AEDX=",

"RIC": "AEDAFN=R",

"Trade Date": "2020-07-20",

"Base Currency Code": "AED",

"Currency Code": "AFN",

"Universal Close Price": 20.9273,

"FXIR Scaling Factor": 1

},

{

"IdentifierType": "ChainRIC",

"Identifier": "AEDX=",

"RIC": "ARSAED=R",

"Trade Date": "2020-07-20",

"Base Currency Code": "ARS",

"Currency Code": "AED",

"Universal Close Price": 5.1215,

"FXIR Scaling Factor": 100

}

],

"Notes": [

"Extraction Services Version 14.1.41724 (be0e0cfc904a), Built Jul 3 2020 14:43:35\r\nHoliday Rollover of Universal Close Price waived.\r\nProcessing started at 07/20/2020 11:05:45 PM.\r\nUser ID: 9023142\r\nExtraction ID: 463006451\r\nSchedule: _OnD_0x072de832b676ba30 (ID = 0x072de832bb06ba30)\r\nInput List (161 items): _OnD_0x072de832b676ba30 (ID = 072de832b746ba30) Created: 07/20/2020 11:05:44 PM Last Modified: 07/20/2020 11:05:44 PM\r\nCHAIN RIC ZWLX= expanded to 0 RICS.\r\nCHAIN RIC AEDX= expanded to 153 RICS: AED= to ZMWAED=R.\r\nCHAIN RIC AFNX= expanded to 24 RICS: AEDAFN=R to WSTAFN=R.\r\nCHAIN RIC ALLX= expanded to 26 RICS: ALL= to XAUALL=R.\r\nCHAIN RIC AMDX= expanded to 23 RICS: AMD= to XAUAMD=R.\r\nCHAIN RIC ANGX= expanded to 22 RICS: ANG= to XAUANG=R.\r\nCHAIN RIC AOAX= expanded to 28 RICS: AOA= to ZARAOA=R.\r\nCHAIN RIC ARSX= expanded to 171 RICS: AEDARS=R to ZMWARS=R.\r\nCHAIN RIC AUDX= expanded to 244 RICS: AEDAUD=R to ZARAUD=R.\r\nCHAIN RIC AWGX= expanded to 21 RICS: ARSAWG=R to XAUAWG=R.\r\nCHAIN RIC AZNX= expanded to 18 RICS: AUDAZN=R to XAUAZN=R.\r\nCHAIN RIC BAMX= expanded to 34 RICS: AUDBAM=R to XAUBAM=R.\r\nCHAIN RIC BBDX= expanded to 34 RICS: ARSBBD=R to XAUBBD=R.\r\nCHAIN RIC BDTX= expanded to 72 RICS: AEDBDT=R to XAUBDT=R.\r\nCHAIN RIC BGNX= expanded to 141 RICS: ARSBGN=R to ZMWBGN=R.\r\nCHAIN RIC BHDX= expanded to 143 RICS: AEDBHD=R to ZMWBHD=R.\r\nCHAIN RIC BIFX= expanded to 22 RICS: AUDBIF=R to ZARBIF=R.\r\nCHAIN RIC BMDX= expanded to 20 RICS: AUDBMD=R to XAUBMD=R.\r\nCHAIN RIC BNDX= expanded to 140 RICS: AEDBND=R to ZMWBND=R.\r\nCHAIN RIC BOBX= expanded to 19 RICS: AUDBOB=R to XAUBOB=R.\r\nCHAIN RIC BRLX= expanded to 167 RICS: AEDBRL=R to ZARBRL=R.\r\nCHAIN RIC BSDX= expanded to 18 RICS: AUDBSD=R to WSTBSD=R.\r\nCHAIN RIC BTNX= expanded to 20 RICS: AUDBTN=R to XAUBTN=R.\r\nCHAIN RIC BWPX= expanded to 233 RICS: AEDBWP=R to ZMWBWP=R.\r\nCHAIN RIC BYNX= expanded to 142 RICS: AEDBYN=R to ZMWBYN=R.\r\nCHAIN RIC BZDX= expanded to 21 RICS: AUDBZD=R to XAUBZD=R.\r\nCHAIN RIC CADX= expanded to 245 RICS: AEDCAD=R to ZMWCAD=R.\r\nCHAIN RIC CDFX= expanded to 25 RICS: ARSCDF=R to ZARCDF=R.\r\nCHAIN RIC CHFX= expanded to 257 RICS: AEDCHF=R to ZMWCHF=R.\r\nCHAIN RIC CLPX= expanded to 150 RICS: AEDCLP=R to ZMWCLP=R.\r\nCHAIN RIC CNHX= expanded to 172 RICS: AEDCNH=R to ZMWCNH=R.\r\nCHAIN RIC CNYX= expanded to 163 RICS: AEDCNY=R to ZMWCNY=R.\r\nCHAIN RIC COPX= expanded to 151 RICS: AEDCOP=R to ZMWCOP=R.\r\nCHAIN RIC CRCX= expanded to 27 RICS: ARSCRC=R to XAUCRC=R.\r\nCHAIN RIC CUPX= expanded to 17 RICS: AUDCUP=R to XAUCUP=R.\r\nCHAIN RIC CVEX= expanded to 26 RICS: AUDCVE=R to XPFCVE=R.\r\nCHAIN RIC CZKX= expanded to 148 RICS: AEDCZK=R to ZMWCZK=R.\r\nCHAIN RIC DJFX= expanded to 24 RICS: AUDDJF=R to XAUDJF=R.\r\nCHAIN RIC DKKX= expanded to 166 RICS: AEDDKK=R to ZMWDKK=R.\r\nCHAIN RIC DOPX= expanded to 28 RICS: ARSDOP=R to XAUDOP=R.\r\nCHAIN RIC DZDX= expanded to 139 RICS: AEDDZD=R to ZMWDZD=R.\r\nCHAIN RIC EGPX= expanded to 157 RICS: AEDEGP=R to ZMWEGP=R.\r\nCHAIN RIC ERNX= expanded to 16 RICS: AUDERN=R to WSTERN=R.\r\nCHAIN RIC ETBX= expanded to 29 RICS: ARSETB=R to ZARETB=R.\r\nCHAIN RIC EURX= expanded to 323 RICS: AEDEUR=R to ZMWEUR=R.\r\nCHAIN RIC FJDX= expanded to 174 RICS: ARSFJD=R to XAUFJD=R.\r\nCHAIN RIC FKPX= expanded to 18 RICS: AUDFKP=R to WSTFKP=R.\r\nCHAIN RIC GBPX= expanded to 301 RICS: AEDGBP=R to ZMWGBP=R.\r\nCHAIN RIC GELX= expanded to 29 RICS: AMDGEL=R to XAUGEL=R.\r\nCHAIN RIC GHSX= expanded to 82 RICS: AUDGHS=R to ZMWGHS=R.\r\nCHAIN RIC GIPX= expanded to 21 RICS: AUDGIP=R to WSTGIP=R.\r\nCHAIN RIC GMDX= expanded to 23 RICS: AUDGMD=R to ZARGMD=R.\r\nCHAIN RIC GNFX= expanded to 26 RICS: AUDGNF=R to ZARGNF=R.\r\nCHAIN RIC GTQX= expanded to 28 RICS: ARSGTQ=R to XAUGTQ=R.\r\nCHAIN RIC GYDX= expanded to 22 RICS: AUDGYD=R to XAUGYD=R.\r\nCHAIN RIC HKDX= expanded to 161 RICS: AEDHKD=R to ZMWHKD=R.\r\nCHAIN RIC HNLX= expanded to 26 RICS: ARSHNL=R to XAUHNL=R.\r\nCHAIN RIC HRKX= expanded to 136 RICS: ARSHRK=R to ZMWHRK=R.\r\nCHAIN RIC HTGX= expanded to 21 RICS: AUDHTG=R to XAUHTG=R.\r\nCHAIN RIC HUFX= expanded to 151 RICS: AEDHUF=R to ZMWHUF=R.\r\nCHAIN RIC IDRX= expanded to 152 RICS: AEDIDR=R to ZMWIDR=R.\r\nCHAIN RIC ILSX= expanded to 134 RICS: AEDILS=R to ZARILS=R.\r\nCHAIN RIC INRX= expanded to 243 RICS: AEDINR=R to ZMWINR=R.\r\nCHAIN RIC IQDX= expanded to 80 RICS: BRLIQD=R to XAUIQD=R.\r\nCHAIN RIC IRRX= expanded to 84 RICS: AEDIRR=R to XAUIRR=R.\r\nCHAIN RIC ISKX= expanded to 99 RICS: AEDISK=R to ZARISK=R.\r\nCHAIN RIC JMDX= expanded to 23 RICS: AUDJMD=R to XAUJMD=R.\r\nCHAIN RIC JODX= expanded to 96 RICS: AEDJOD=R to XAUJOD=R.\r\nCHAIN RIC JPYX= expanded to 209 RICS: AEDJPY=R to ZARJPY=R.\r\nCHAIN RIC KESX= expanded to 152 RICS: AEDKES=R to ZMWKES=R.\r\nCHAIN RIC KGSX= expanded to 22 RICS: AUDKGS=R to XAUKGS=R.\r\nCHAIN RIC KHRX= expanded to 37 RICS: AUDKHR=R to XAUKHR=R.\r\nCHAIN RIC KMFX= expanded to 24 RICS: AUDKMF=R to XPFKMF=R.\r\nCHAIN RIC KPWX= expanded to 16 RICS: AUDKPW=R to WSTKPW=R.\r\nCHAIN RIC KRWX= expanded to 151 RICS: AEDKRW=R to ZMWKRW=R.\r\nCHAIN RIC KWDX= expanded to 145 RICS: AEDKWD=R to ZMWKWD=R.\r\nCHAIN RIC KYDX= expanded to 22 RICS: AUDKYD=R to XAUKYD=R.\r\nCHAIN RIC KZTX= expanded to 146 RICS: AEDKZT=R to ZMWKZT=R.\r\nCHAIN RIC LAKX= expanded to 39 RICS: AUDLAK=R to XAULAK=R.\r\nCHAIN RIC LBPX= expanded to 95 RICS: AEDLBP=R to ZARLBP=R.\r\nCHAIN RIC LKRX= expanded to 140 RICS: AEDLKR=R to ZMWLKR=R.\r\nCHAIN RIC LRDX= expanded to 21 RICS: ARSLRD=R to WSTLRD=R.\r\nCHAIN RIC LSLX= expanded to 23 RICS: AUDLSL=R to ZARLSL=R.\r\nCHAIN RIC LYDX= expanded to 87 RICS: AEDLYD=R to ZMWLYD=R.\r\nCHAIN RIC MADX= expanded to 163 RICS: AEDMAD=R to ZMWMAD=R.\r\nCHAIN RIC MDLX= expanded to 29 RICS: AUDMDL=R to XAUMDL=R.\r\nCHAIN RIC MGAX= expanded to 20 RICS: AUDMGA=R to XAUMGA=R.\r\nCHAIN RIC MKDX= expanded to 132 RICS: AEDMKD=R to ZMWMKD=R.\r\nCHAIN RIC MMKX= expanded to 35 RICS: AUDMMK=R to XAUMMK=R.\r\nCHAIN RIC MNTX= expanded to 31 RICS: AUDMNT=R to XAUMNT=R.\r\nCHAIN RIC MOPX= expanded to 52 RICS: ARSMOP=R to XAUMOP=R.\r\nCHAIN RIC MRUX= expanded to 23 RICS: AUDMRU=R to XAUMRU=R.\r\nCHAIN RIC MURX= expanded to 45 RICS: ARSMUR=R to ZARMUR=R.\r\nCHAIN RIC MVRX= expanded to 22 RICS: AUDMVR=R to XAUMVR=R.\r\nCHAIN RIC MWKX= expanded to 31 RICS: ARSMWK=R to ZMWMWK=R.\r\nCHAIN RIC MXNX= expanded to 157 RICS: AEDMXN=R to ZMWMXN=R.\r\nCHAIN RIC MYRX= expanded to 66 RICS: AEDMYR=R to ZARMYR=R.\r\nCHAIN RIC MZNX= expanded to 31 RICS: AUDMZN=R to ZARMZN=R.\r\nCHAIN RIC NADX= expanded to 32 RICS: AUDNAD=R to ZARNAD=R.\r\nCHAIN RIC NGNX= expanded to 154 RICS: AEDNGN=R to ZMWNGN=R.\r\nCHAIN RIC NIOX= expanded to 24 RICS: ARSNIO=R to XAUNIO=R.\r\nCHAIN RIC NOKX= expanded to 162 RICS: AEDNOK=R to ZMWNOK=R.\r\nCHAIN RIC NPRX= expanded to 38 RICS: ARSNPR=R to XAUNPR=R.\r\nCHAIN RIC NZDX= expanded to 250 RICS: AEDNZD=R to ZMWNZD=R.\r\nCHAIN RIC OMRX= expanded to 141 RICS: AEDOMR=R to ZMWOMR=R.\r\nCHAIN RIC PABX= expanded to 21 RICS: ARSPAB=R to XAUPAB=R.\r\nCHAIN RIC PENX= expanded to 148 RICS: AEDPEN=R to ZMWPEN=R.\r\nCHAIN RIC PGKX= expanded to 176 RICS: ARSPGK=R to XAUPGK=R.\r\nCHAIN RIC PHPX= expanded to 146 RICS: AEDPHP=R to ZMWPHP=R.\r\nCHAIN RIC PKRX= expanded to 132 RICS: AEDPKR=R to ZMWPKR=R.\r\nCHAIN RIC PLNX= expanded to 153 RICS: AEDPLN=R to ZMWPLN=R.\r\nCHAIN RIC PYGX= expanded to 22 RICS: AUDPYG=R to XAUPYG=R.\r\nCHAIN RIC QARX= expanded to 150 RICS: AEDQAR=R to ZMWQAR=R.\r\nCHAIN RIC RONX= expanded to 99 RICS: AUDRON=R to ZARRON=R.\r\nCHAIN RIC RSDX= expanded to 136 RICS: AEDRSD=R to ZMWRSD=R.\r\nCHAIN RIC RUBX= expanded to 242 RICS: AEDRUB=R to ZMWRUB=R.\r\nCHAIN RIC RWFX= expanded to 26 RICS: AUDRWF=R to ZARRWF=R.\r\nCHAIN RIC SARX= expanded to 171 RICS: AEDSAR=R to ZMWSAR=R.\r\nCHAIN RIC SBDX= expanded to 168 RICS: AUDSBD=R to XAUSBD=R.\r\nCHAIN RIC SCRX= expanded to 25 RICS: AUDSCR=R to ZARSCR=R.\r\nCHAIN RIC SDGX= expanded to 24 RICS: AEDSDG=R to XAFSDG=R.\r\nCHAIN RIC SEKX= expanded to 175 RICS: AEDSEK=R to ZMWSEK=R.\r\nCHAIN RIC SGDX= expanded to 69 RICS: AEDSGD=R to ZARSGD=R.\r\nCHAIN RIC SHPX= expanded to 19 RICS: AUDSHP=R to WSTSHP=R.\r\nCHAIN RIC SLLX= expanded to 24 RICS: AUDSLL=R to ZARSLL=R.\r\nCHAIN RIC SSPX= expanded to 21 RICS: CHFSSP=R to XAFSSP=R.\r\nCHAIN RIC SOSX= expanded to 20 RICS: AUDSOS=R to WSTSOS=R.\r\nCHAIN RIC SRDX= expanded to 21 RICS: AUDSRD=R to XAUSRD=R.\r\nCHAIN RIC STNX= expanded to 18 RICS: AUDSTN=R to WSTSTN=R.\r\nCHAIN RIC SVCX= expanded to 20 RICS: ARSSVC=R to XAUSVC=R.\r\nCHAIN RIC SYPX= expanded to 82 RICS: AEDSYP=R to WSTSYP=R.\r\nCHAIN RIC SZLX= expanded to 22 RICS: AUDSZL=R to WSTSZL=R.\r\nCHAIN RIC THBX= expanded to 167 RICS: AEDTHB=R to ZMWTHB=R.\r\nCHAIN RIC TJSX= expanded to 13 RICS: AUDTJS=R to XAUTJS=R.\r\nCHAIN RIC TMTX= expanded to 14 RICS: AUDTMT=R to XAUTMT=R.\r\nCHAIN RIC TNDX= expanded to 61 RICS: AEDTNDX=R to ZARTNDX=R.\r\nCHAIN RIC TOPX= expanded to 167 RICS: AUDTOP=R to XAUTOP=R.\r\nCHAIN RIC TRYX= expanded to 152 RICS: AEDTRY=R to ZMWTRY=R.\r\nCHAIN RIC TTDX= expanded to 56 RICS: AEDTTD=R to XAUTTD=R.\r\nCHAIN RIC TWDX= expanded to 143 RICS: AEDTWD=R to ZMWTWD=R.\r\nCHAIN RIC TZSX= expanded to 141 RICS: AEDTZS=R to ZARTZS=R.\r\nCHAIN RIC UAHX= expanded to 138 RICS: AEDUAH=R to ZMWUAH=R.\r\nCHAIN RIC UGXX= expanded to 147 RICS: AEDUGX=R to ZMWUGX=R.\r\nCHAIN RIC UYUX= expanded to 38 RICS: AUDUYU=R to XAUUYU=R.\r\nCHAIN RIC UZSX= expanded to 23 RICS: AUDUZS=R to XAUUZS=R.\r\nCHAIN RIC VEFX= expanded to 1 RIC: VEF=.\r\nCHAIN RIC VESX= expanded to 64 RICS: AEDVES=R to ZARVES=R.\r\nCHAIN RIC VNDX= expanded to 149 RICS: AEDVND=R to ZMWVND=R.\r\nCHAIN RIC VUVX= expanded to 27 RICS: AUDVUV=R to XAUVUV=R.\r\nCHAIN RIC WSTX= expanded to 167 RICS: AUDWST=R to XAUWST=R.\r\nCHAIN RIC XAFX= expanded to 44 RICS: ARSXAF=R to ZARXAF=R.\r\nCHAIN RIC XAGX= expanded to 110 RICS: AUDXAG=R to ZMWXAG=R.\r\nCHAIN RIC XAUX= expanded to 176 RICS: AUDXAU=R to ZMWXAU=R.\r\nCHAIN RIC XCDX= expanded to 20 RICS: AUDXCD=R to XCDUSD=R.\r\nCHAIN RIC XOFX= expanded to 52 RICS: AEDXOF=R to ZARXOF=R.\r\nCHAIN RIC XPDX= expanded to 129 RICS: AEDXPD=R to ZMWXPD=R.\r\nCHAIN RIC XPFX= expanded to 30 RICS: ARSXPF=R to XPFXOF=R.\r\nCHAIN RIC XPTX= expanded to 132 RICS: AEDXPT=R to ZMWXPT=R.\r\nCHAIN RIC YERX= expanded to 137 RICS: AEDYER=R to ZMWYER=R.\r\nCHAIN RIC ZARX= expanded to 184 RICS: AEDZAR=R to ZMWZAR=R.\r\nCHAIN RIC ZMWX= expanded to 143 RICS: AEDZMW=R to ZMWZAR=R.\r\nTotal instruments after instrument expansion = 14471\r\nSchedule Time: 07/20/2020 11:05:44 PM\r\nReport Template (12 fields): _OnD_0x072de832b676ba30 (ID = 0x072de832b696ba30) Created: 07/20/2020 11:05:44 PM Last Modified: 07/20/2020 11:05:44 PM\r\nProcessing completed successfully at 07/20/2020 11:06:11 PM, taking 25.9 Secs.\r\nExtraction finished at 07/21/2020 03:06:11 AM UTC, with servers: x08i06, QSHC15 (5.2 secs), QSSHA1 (0.0 secs)\r\nUsage Summary for User 9023142, Client 110043, Template Type EOD Pricing\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 24 Commodities N/A N/A\r\n 14447 Money Market N/A N/A\r\n-------\r\n 14471 Total instruments charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 14471 Instruments in the input list.\r\nNo TRPS complex usage to report -- 14471 Instruments in the input list had no reported data.\r\n"

]

}

Comment

Hi @gurukrishna.santosh.kumar.ippili,

It seems that the error was generated in the client application. Could you share the code you are using to deserialize data?

Hi @veerapath.rungruengrayubkul

This issue is solved. I need to add nullable property in .Net like below. Initially I didn't use nullable on FXIRScalingFactor property.

Best Answer

This issue is solved. I need to add nullable property in .Net like below. Initially I didn't use nullable on FXIRScalingFactor property.

[JsonPropertyName("FXIR Scaling Factor")]

public double? FXIRScalingFactor { get; set; }

@gurukrishna.santosh.kumar.ippili,

Thank you for the update. Glad to know that the issue has been solved.

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

- Anonymous
- Sign in
- Create
- Ask a question
- Spaces
- Alpha
- App Studio
- Block Chain
- Bot Platform
- Connected Risk APIs
- DSS
- Data Fusion
- Data Model Discovery
- Datastream
- Eikon COM
- Eikon Data APIs
- Electronic Trading
- Elektron
- Intelligent Tagging
- Legal One
- Messenger Bot
- Messenger Side by Side
- ONESOURCE
- Open Calais
- Open PermID
- Org ID
- PAM
- ProView
- ProView Internal
- Product Insight
- Project Tracking
- RDMS
- Refinitiv Data Platform
- Rose's Space
- Screening
- Side by Side Integration API
- TR Knowledge Graph
- TREP APIs
- TREP Infrastructure
- TRKD
- TRTH
- Thomson One Smart
- Transactions
- Velocity Analytics
- Wealth Management Web Services
- Workspace SDK
- World-Check Data File
- 中文论坛
- Explore
- Tags
- Questions
- Badges