Genesys Cloud - Developer Community!

Hi Mahmoud, let me know if this is what you are looking for:

To get the last queueId using JSONPath, you can use the following syntax:

$..queueId[-1]

This breaks down as:

• $: represents the root of the JSON document
• ..: recursive descent operator that searches for the key at any level
• queueId: the specific key you're looking for
• [-1]: array index selector that gets the last element

Alternatively, if your queueIds are in a specific array and you know the exact path, you can use:

$.path.to.array.queueId[-1]

You can test your JSONPath expressions using online tools like https://jsonpath.com/ to verify the results with your specific JSON structure.

This syntax is based on the standard JSONPath operators where $ is the root element, .. is used for recursive descent to search for a key at any level, and [] is the subscript operator used to access array elements.

Thank you Joaquin for your input 
the  Jsonpath $..queueId[-1] didnt work as the queue ID is not an array

I am using used the flowing API
get /api/v2/analytics/conversations/{conversationId}/details
I was able to use the following jsonpath  $.participants[?(@.purpose == "acd")].participantName

but it gave me all participantNames with the purpose of "acd" 
That help little bit,  but i am looing to get the last ParticpantName only, any Idea ??

Hi Mahmoud, let me know if this is what you are looking for:

To get the last queueId using JSONPath, you can use the following syntax:

$..queueId[-1]

This breaks down as:

• $: represents the root of the JSON document
• ..: recursive descent operator that searches for the key at any level
• queueId: the specific key you're looking for
• [-1]: array index selector that gets the last element

Alternatively, if your queueIds are in a specific array and you know the exact path, you can use:

$.path.to.array.queueId[-1]

You can test your JSONPath expressions using online tools like https://jsonpath.com/ to verify the results with your specific JSON structure.

This syntax is based on the standard JSONPath operators where $ is the root element, .. is used for recursive descent to search for a key at any level, and [] is the subscript operator used to access array elements.

Try to use JSONPath Online Evaluator

Json Path for queueId: $.participants[?(@.purpose=='agent')].sessions[*].segments[?(@.queueId)].queueId (Take the last id)

Json Path for wrap-up id and name: $.participants[?(@.purpose=='agent')].sessions[*].segments[?(@.wrapUpCode)].wrapUpCode

Thank you Joaquin for your input 
the  Jsonpath $..queueId[-1] didnt work as the queue ID is not an array

I am using used the flowing API
get /api/v2/analytics/conversations/{conversationId}/details
I was able to use the following jsonpath  $.participants[?(@.purpose == "acd")].participantName

but it gave me all participantNames with the purpose of "acd" 
That help little bit,  but i am looing to get the last ParticpantName only, any Idea ??

Hi Mahmoud, let me know if this is what you are looking for:

To get the last queueId using JSONPath, you can use the following syntax:

$..queueId[-1]

This breaks down as:

• $: represents the root of the JSON document
• ..: recursive descent operator that searches for the key at any level
• queueId: the specific key you're looking for
• [-1]: array index selector that gets the last element

Alternatively, if your queueIds are in a specific array and you know the exact path, you can use:

$.path.to.array.queueId[-1]

You can test your JSONPath expressions using online tools like https://jsonpath.com/ to verify the results with your specific JSON structure.

This syntax is based on the standard JSONPath operators where $ is the root element, .. is used for recursive descent to search for a key at any level, and [] is the subscript operator used to access array elements.

Thank you Mateus for your input, i really appreciate it

Try to use JSONPath Online Evaluator

Json Path for queueId: $.participants[?(@.purpose=='agent')].sessions[*].segments[?(@.queueId)].queueId (Take the last id)

Json Path for wrap-up id and name: $.participants[?(@.purpose=='agent')].sessions[*].segments[?(@.wrapUpCode)].wrapUpCode

Thank you Joaquin for your input 
the  Jsonpath $..queueId[-1] didnt work as the queue ID is not an array

I am using used the flowing API
get /api/v2/analytics/conversations/{conversationId}/details
I was able to use the following jsonpath  $.participants[?(@.purpose == "acd")].participantName

but it gave me all participantNames with the purpose of "acd" 
That help little bit,  but i am looing to get the last ParticpantName only, any Idea ??

Hi Mahmoud, let me know if this is what you are looking for:

To get the last queueId using JSONPath, you can use the following syntax:

$..queueId[-1]

This breaks down as:

• $: represents the root of the JSON document
• ..: recursive descent operator that searches for the key at any level
• queueId: the specific key you're looking for
• [-1]: array index selector that gets the last element

Alternatively, if your queueIds are in a specific array and you know the exact path, you can use:

$.path.to.array.queueId[-1]

You can test your JSONPath expressions using online tools like https://jsonpath.com/ to verify the results with your specific JSON structure.

This syntax is based on the standard JSONPath operators where $ is the root element, .. is used for recursive descent to search for a key at any level, and [] is the subscript operator used to access array elements.