Data Action to get Data From Data Table , retrieve values from column with blank space names

Data Actions
1

Hello,

I have a use case where a need to get the values from different columns in my data table given a specific row.
I implemented a data action calling this api : /api/v2/flows/datatables/${input.dataTableId}/rows/${input.dataTableKey.replace(" ", "%20")}?showbrief=false

The columns of the data tables are the following : Closed , Start Hours , End Hours.

my translationMap looks like this :


{
  "translationMap": {
    "closed": "$.Closed",
    "EndHours": "$.End Hours",
    "StartHours": "$.Start Hours"
  },
  "translationMapDefaults": {


"closed": "\"\"",
"StartHours": "\"\"",
"EndHours" : "\"\""

},

  "successTemplate": "{\n  \"closed\": ${closed}\n,\n  \"StartHours\": ${StartHours}\n,\n  \"EndHours\": ${EndHours}\n}"
}

I have no problem retrieving the value of the "Closed" column, but in the response "Start Hours" and "End Hours" remains empty and I guess this is due to the white space.
When using https://jsonpath.com/ with "$.Start Hours" it perfectly works.

Could you please assist? :slight_smile:
Thanks in advance.

Nathan

2

Spaces in keys can be a problem. See if one of these works:
$.[End Hours]
$.['End Hours']

--Jason

3

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.