Filtering in json response

Help Studio
, ,
1

I need to take conversation ID where status is not completed . This is my json response

“data”: [
{
“id”: “648c3b4d1c5b4be32ec66603”,
“type”: “work_item”,
“attributes”: {
“resourceType”: “conversation”,
“status”: “completed”,
“paused”: false,
“channel”: “twitter-dm”,
“firstEnterQueueAt”: “2023-06-16T10:37:01.715Z”,
“queuedCount”: 1,
“priority”: 1,
“itemSize”: 1,
“completedAt”: “2023-08-04T08:20:15.384Z”,
“updatedAt”: “2023-08-04T08:20:15.384Z”,
“modifiedAt”: “2023-06-16T10:37:01.725Z”,
“createdAt”: “2023-06-16T10:37:01.715Z”,
“resourceRev”: 304,
“resourceCreatedAt”: “2022-12-12T10:34:44.906Z”,
“resourceDirection”: “in”,
“rev”: 2,
“workItemNumber”: 16,
“hasSkills”: false,
“skills”: ,
“lastRevision”: {
“enteredQueueAt”: “2023-06-16T10:37:01.715Z”,
“queueTime”: 4225393669,
“queueBusinessTime”: 4225393669
},
“resource”: {
“id”: “639703c42ada68c4f685a4df”,
“priority”: 3,
“sla”: {
“breachAt”: “2022-12-12T10:35:14.906Z”
},
“status”: “open”,
“lastMessageUnrespondedToSentAt”: “2022-12-12T10:34:44.899Z”
}
},
“relationships”: {
“org”: {
“data”: {
“type”: “org”,
“id”: “5c3793b2693073001983a86a”
},
“links”: {
“self”: “/v1/orgs/5c3793b2693073001983a86a”
}
},
“resource”: {
“data”: {
“type”: “conversation”,
“id”: “639703c42ada68c4f685a4df”
}
},
“lastRevision”: {
“data”: {
“type”: “work_item_revision”,
“id”: “648c3b4d1c5b4b5d15c66604”
}
},
“queue”: {
“data”: {
“type”: “queue”,
“id”: “637b96b170397c24906f6aaf”
},
“links”: {
“self”: “/v1/routing/queues/637b96b170397c24906f6aaf”
}
}
},
“links”: {
“self”: “/v1/routing/work-items/648c3b4d1c5b4be32ec66603”
}
}
]
}

Current linq i use is DeserializeJsonOutputGetConversationID(“data”).Select(Function (x) x (“relationships”)(“resource”)(“data”)(“id”).value(of string) ).toArray .I tried adding WHERE condition but getting validation error

2

Hello @tharani.natarajan, try this:

DeserializeJsonOutputGetConversationID(“data”) _
.Where(Function(x) x(“attributes”)(“status”).ToString() <> “completed”) _
.Select(Function(x) x(“relationships”)(“resource”)(“data”)(“id”).Value(Of String)) _
.ToArray()

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.