"message": "Malformed request payload: Syntax error at Line 1, Char 1: expected valid json array ...

Huggins Mafigu

...or json object "

I'm making an http request to the api using the below details but I'm getting the 400 error with the above message.

URI: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes

Headers:

{
  "Accept": "application/json; odata.metadata=minimal",
  "Authorization": "Token xxxxx",
  "Content-Type": "application/json; odata=minimalmetadata; charset=utf-8"
}

Body:

{
  "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:

{
  "error": {
    "message": "Malformed request payload: Syntax error at Line 1, Char 1: expected valid json array or json object "
  }
}

Jirapongse

@Huggins Mafigu

I checked and found that It is a quite tricky to use DSS REST API on Azure Logic App.

First, the Azure Logic App can re-order the keys in the JSON body which causes the issue on DSS. Therefore, DSS will reject the request. The workaround is using a string variable that contains the JSON string.

Then, use this string variable in the HTTP action.

I found this solution on this page.

However, the default size of the variable is 1024 bytes so you may need to increase this default value (Runtime.Backend.VariableOperation.MaximumStatelessVariableSize). Please check the following links to change this value.

• https://learn.microsoft.com/en-us/azure/logic-apps/edit-app-settings-host-settings?tabs=azure-portal#reference-local-settings-json
• https://learn.microsoft.com/en-us/azure/logic-apps/edit-app-settings-host-settings?tabs=azure-portal#manage-host-settings

You need to change this value in host.json file.

{
  "version": "2.0",
  "extensionBundle": {
    "id": "Microsoft.Azure.Functions.ExtensionBundle.Workflows",
    "version": "[1.*, 2.0.0)"
  },
  "extensions": {
      "workflow": {
         "settings": {
            "Runtime.Backend.VariableOperation.MaximumStatelessVariableSize": "5000"
         }
      }
   }
}