BizTalk Adapter for Amazon DynamoDB

Build 20.0.7654

Projection Functions

JSON_AVG(json, jsonpath)

Computes the average value of a JSON array within a JSON object.

  • json: The column containing JSON data.
  • jsonpath: The path to the json array.

JSON_COUNT(json, jsonpath)

Returns the number of elements in a JSON array within a JSON object.

  • json: The column containing JSON data.
  • jsonpath: The path to the json array.

JSON_MAX(json, jsonpath)

Gets the maximum value in a JSON array within a JSON object.

  • json: The column containing JSON data.
  • jsonpath: The path to the json array.

JSON_MIN(json, jsonpath)

Gets the minimum value in a JSON array within a JSON object.

  • json: The column containing JSON data.
  • jsonpath: The path to the json array.

JSON_SUM(json, jsonpath)

Computes the sum of the elements in a JSON within a JSON object.

  • json: The column containing JSON data.
  • jsonpath: The path to the json array.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654