Guest

Preview Tool

Cisco Bug: CSCvu30670 - Read Table from JSON returns one row when no rows are found

Last Modified

May 29, 2020

Products (1)

  • Cisco CloudCenter Suite

Known Affected Releases

5.1(4)

Description (partial)

Symptom:
Activities within iteration may get unexpected results and workflows may fail as a result. If you are using variable types other than string, the single item in the array will be populated with variables that are strings rather than the type expected / set in the Read Table from JSON activity

Conditions:
Utilizing the Read Table from JSON activity and the resultant array should be empty. For example if your source JSON is [] and your column is "test" The activity output will be:

{
  "output": {
    "activity_status": "Success",
    "response": {
      "elapsed_time": 0.133578583,
      "end_time": "2020-05-18T21:51:39.04083636Z",
      "read_table_from_json": [
        {
          "test": ""
        }
      ],
      "response_body": "[{\"test\":\"\"}]",
      "row_count": 0,
      "start_time": "2020-05-18T21:51:38.907257777Z",
      "succeeded": true
    }
  }
}

Notice the row_count of 0 but we got an array item. Please note that for other variable types you will still get an empty string.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.