{"error":{"message":"Malformed request payload: For the property name \"StartDate\" in the JSON request the value could not be parsed successfully. Please check the casing or spelling of the property."}}
Extraction request below:
from collections import OrderedDict import requests import json url = "https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes" header3 = { 'Prefer': 'respond-async', 'Content-Type': 'application/json; odata=minimalmetadata', 'Authorization': 'Token'+'MyToken' }listIdentifiers = [{"Identifier":"SARON.S","IdentifierType":"Ric"}] fromdate = "2023-03-05" todate = "2023-03-09" odataType = "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest" condition = {"StartDate": fromdate + "T00:00:00.000Z","EndDate": todate + "T00:00:00.000Z"} listFields = ["Trade Date","Currency Code","Universal Close Price"] payload = {"ExtractionRequest":OrderedDict([("@odata.type", odataType),("ContentFieldNames", listFields),("IdentifierList", OrderedDict([("@odata.type", "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList"),("InstrumentIdentifiers", listIdentifiers)])),("Condition",condition)])} response = requests.post(url, data=json.dumps(payload), headers=header3, timeout=15) print(response.text)
