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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted

Unable to Deserialize when ContentFieldNames contains FXIR Scaling Factor and getting error In .Net api side

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"

]

}

dss-rest-apidatascope-selectdssforexdeserialize
icon clock
10 |1500

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

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.

1 Answer

Upvotes
Accepted

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; }

icon clock
10 |1500

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

@gurukrishna.santosh.kumar.ippili,

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

Click below to post an Idea Post Idea