Get the value of response JSON node or nodes in text format. For detailed description and examples see Processing API Response with Code.
Function uses JSONPath expressions for JSON filtering – see some examples and basic description here.
Text - Specifies the JSONPath expression for filtering JSON node or nodes.Text Value of the JSON node or nodes in text or JSON format.
//Returns text in name node
NodeValue := APIScriptRWU.GET_RESPONSE_VALUE_BY_JPATH('$.name');
//Returns id of the first customer
NodeValue := APIScriptRWU.GET_RESPONSE_VALUE_BY_JPATH('$.customer[0].id');
//Returns second phone of the first customer
NodeValue := APIScriptRWU.GET_RESPONSE_VALUE_BY_JPATH('$.customer[0].phones[1]');
Function does not work properly with paginated result – it returns data from last page only.