Legacy Dev Forum Posts

 View Only

Sign Up

Back to discussions
Expand all | Collapse all

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

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

    Posted 06-05-2025 18:46

    Nathan_Tossens | 2024-06-25 08:10:59 UTC | #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

    Jason_Mathison | 2024-06-25 13:39:33 UTC | #2

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

    --Jason

    system | 2024-07-26 13:40:01 UTC | #3

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

    This post was migrated from the old Developer Forum.

    ref: 26938



Related Content