AWS StepFunctions: sum() function returns error about not finding path

Question

I have a StepFunction with input:

```json
{
  "Jobs": [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0]
}
```

and I want the sum of the values in this array. According to the [Json-Path docs](https://github.com/json-path/JsonPath) there should exist a `.sum()` function for this. When I try it [here](http://jsonpath.herokuapp.com/) it even works. So I defined the following Pass state:

```json
"Sum Jobs": {
  "Type": "Pass",
  "Parameters": {
   "Jobs.$": "$.Jobs.sum()"
  }
},
```

Nevertheless executions fail with:

```
"An error occurred while executing the state 'Sum Jobs' (entered at the event id #249). The JSONPath '$.Jobs.sum()' specified for the field 'Jobs.$' could not be found in the input '{\"Jobs\":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0]}'"
```

Answer

AWS Step Functions does not support functions in the path reference. It uses JSONPath expressions to identify a node, however has the following constraints:
* You can access object fields using only dot (.) and square bracket ([ ]) notation.
* The operators @ .. , : ? * aren't supported.
* Functions such as length() aren't supported.

This Step Functions documentation that covers this can be found [here](https://docs.aws.amazon.com/step-functions/latest/dg/amazon-states-language-paths.html#amazon-states-language-reference-paths).

AWS StepFunctions: sum() function returns error about not finding path

Relevant questions

I am having an issue in API Gateway that says " No integration defined for method" when I attempt to deploy

FAILED: Execution Error, return code 1

Scheduling local lambda function

Is Lambda invocation = 0 is a guaranteed metric that proves the Lambda function was unused during the period I provide to metric?

Can I specify GET URL path parameter in step function?

Internal Server Error from API Gateway when sending queries through gateway to Lambda function connected to RDS database

How to delete glue interactive session from the list of sessions?

AWS StepFunctions: sum() function returns error about not finding path

How to delete jobs?

CloudFront does not seem to invoke lambda@edge function