Webhook Get Json Value

This activity allows you to retrieve a single value (string, decimal, whole number, guid etc. using JsonPath query notation.

Examples:

• Retrieve an email address from the response to an API call.

Input Parameters

Parameter Name	Type	Description	Default
Json String	Text	The Json string value to search.	{null}
Json Path	Text	The JsonPath query string to get the value.	{null}

Output Parameters

Parameter Name	Type	Description
Single Value - Result as Whole Number	Whole Number	The result of the JsonPath query, if the value can be parsed as a whole number
Single Value - Result as DateTime	Date Time	The result of the JsonPath query, if the value is a date time.
Single Value - Result as Decimal	Decimal	The result of the JsonPath query, if the value can be parsed as a decimal.
Single Value - Result as Double	Double	The result of the JsonPath query, if the value can be parsed as a double.
Single Value - Result as Money	Money	The result of the JsonPath query, if the value can be parsed as a decimal (then cast as a Money).
Single Value - Result as Text	Text	The result of the JsonPath query, first column of the result set.