I’m making an http request to the api using the below details but I’m getting the 400 error with the above message.
On postman it is working fine, but when I try it on Azure Logic Apps, it’s not going through. I’ve checked couple of similiar posts but still no luck.
Any assistance in pointing to the right direction is appreciated.
Headers:
<code>{
"Accept": "application/json; odata.metadata=minimal",
"Authorization": "Token xxxxx",
"Content-Type": "application/json; odata=minimalmetadata; charset=utf-8"
}
</code>
<code>{
"Accept": "application/json; odata.metadata=minimal",
"Authorization": "Token xxxxx",
"Content-Type": "application/json; odata=minimalmetadata; charset=utf-8"
}
</code>
{
"Accept": "application/json; odata.metadata=minimal",
"Authorization": "Token xxxxx",
"Content-Type": "application/json; odata=minimalmetadata; charset=utf-8"
}
Body:
<code>{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
"ContentFieldNames": [
"RIC",
"Ask Price",
"Asset Type",
"Bid Price",
"Currency Code",
"Exchange Code",
"High Price",
"Instrument ID",
"Instrument ID Type",
"Low Price",
"Open Price",
"Previous Close Date",
"Previous Close Price",
"Security Description",
"Settlement Price",
"Trade Date",
"User Defined Identifier",
"Volume"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "438516AC0",
"IdentifierType": "Cusip"
},
{
"Identifier": "IBM.N",
"IdentifierType": "Ric"
},
{
"Identifier": "JPYUSD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "USDAUD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "EURGBP=R",
"IdentifierType": "Ric"
},
{
"Identifier": "EURZAR=R",
"IdentifierType": "Ric"
},
{
"Identifier": "ZARUSD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "USDZAR=R",
"IdentifierType": "Ric"
}
]
},
"Condition": { "ScalableCurrency": true }
}
}
</code>
<code>{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
"ContentFieldNames": [
"RIC",
"Ask Price",
"Asset Type",
"Bid Price",
"Currency Code",
"Exchange Code",
"High Price",
"Instrument ID",
"Instrument ID Type",
"Low Price",
"Open Price",
"Previous Close Date",
"Previous Close Price",
"Security Description",
"Settlement Price",
"Trade Date",
"User Defined Identifier",
"Volume"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "438516AC0",
"IdentifierType": "Cusip"
},
{
"Identifier": "IBM.N",
"IdentifierType": "Ric"
},
{
"Identifier": "JPYUSD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "USDAUD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "EURGBP=R",
"IdentifierType": "Ric"
},
{
"Identifier": "EURZAR=R",
"IdentifierType": "Ric"
},
{
"Identifier": "ZARUSD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "USDZAR=R",
"IdentifierType": "Ric"
}
]
},
"Condition": { "ScalableCurrency": true }
}
}
</code>
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
"ContentFieldNames": [
"RIC",
"Ask Price",
"Asset Type",
"Bid Price",
"Currency Code",
"Exchange Code",
"High Price",
"Instrument ID",
"Instrument ID Type",
"Low Price",
"Open Price",
"Previous Close Date",
"Previous Close Price",
"Security Description",
"Settlement Price",
"Trade Date",
"User Defined Identifier",
"Volume"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "438516AC0",
"IdentifierType": "Cusip"
},
{
"Identifier": "IBM.N",
"IdentifierType": "Ric"
},
{
"Identifier": "JPYUSD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "USDAUD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "EURGBP=R",
"IdentifierType": "Ric"
},
{
"Identifier": "EURZAR=R",
"IdentifierType": "Ric"
},
{
"Identifier": "ZARUSD=R",
"IdentifierType": "Ric"
},
{
"Identifier": "USDZAR=R",
"IdentifierType": "Ric"
}
]
},
"Condition": { "ScalableCurrency": true }
}
}
Response:
<code>{
"error": {
"message": "Malformed request payload: Syntax error at Line 1, Char 1: expected valid json array or json object "
}
}
</code>
<code>{
"error": {
"message": "Malformed request payload: Syntax error at Line 1, Char 1: expected valid json array or json object "
}
}
</code>
{
"error": {
"message": "Malformed request payload: Syntax error at Line 1, Char 1: expected valid json array or json object "
}
}
See below images