Share
Report
2,100i have this sample JSON array:-
[
{
"@Id": "18894263",
"@AgentId": "-101",
"@CallDuration": "0:00:29",
"@CallOrigin": "Inbound",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 1:24:22 AM",
"@Campaign": "Test",
"@ContactId": "2618567",
"@Group": "",
"@InboundPhone": "+15102818273",
"@LeadFullName": "**",
"@LeadId": "2618567",
"@ProspectPhone": "+15104159559",
"@RecordingUrl": "",
"@Result": "Conversation (External)",
"@TargetNumber": "+1 800-355-2116",
"@User": "",
"@WaitTime": "",
"@CallId": "F3F7CDB5-1C06-402D-AFF1-86B194BF65C9"
},
{
"@Id": "18894266",
"@AgentId": "-101",
"@CallDuration": "0:00:16",
"@CallOrigin": "Inbound",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 2:21:16 AM",
"@Campaign": "Test",
"@ContactId": "2726390",
"@Group": "",
"@InboundPhone": "+13153655044",
"@LeadFullName": "**",
"@LeadId": "2726390",
"@ProspectPhone": "+13152815642",
"@RecordingUrl": "",
"@Result": "Conversation (External)",
"@TargetNumber": "+1 800-355-2116",
"@User": "",
"@WaitTime": "",
"@CallId": "70872967-38DE-492D-A921-8022CD35EE87"
},
{
"@Id": "18894267",
"@AgentId": "11663",
"@CallDuration": "0:00:12",
"@CallOrigin": "Outbound - Manual",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 4:56:55 AM",
"@Campaign": "Internet",
"@ContactId": "4182053",
"@Group": "Brokers",
"@InboundPhone": "",
"@LeadFullName": "***",
"@LeadId": "4182053",
"@ProspectPhone": "+19407352562",
"@RecordingUrl": "",
"@Result": "Conversation",
"@TargetNumber": "+1 515-498-1137",
"@User": "**, **",
"@WaitTime": "",
"@CallId": "AA4B19DB-7995-42CB-B0FF-36B53336CCFD"
},
{
"@Id": "18894268",
"@AgentId": "11663",
"@CallDuration": "0:34:47",
"@CallOrigin": "Outbound - Manual",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 4:58:20 AM",
"@Campaign": "Internet",
"@ContactId": "4182053",
"@Group": "Brokers",
"@InboundPhone": "",
"@LeadFullName": "****",
"@LeadId": "4182053",
"@ProspectPhone": "+19407352562",
"@RecordingUrl": "",
"@Result": "Conversation",
"@TargetNumber": "+1 515-498-1137",
"@User": "**, James",
"@WaitTime": "",
"@CallId": "976CB0F1-DD9A-4CB1-BA80-5A60BBF342CC"
},
{
"@Id": "18894271",
"@AgentId": "-101",
"@CallDuration": "0:00:19",
"@CallOrigin": "Inbound",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 5:41:23 AM",
"@Campaign": "Test",
"@ContactId": "4201584",
"@Group": "",
"@InboundPhone": "+18507505298",
"@LeadFullName": "***",
"@LeadId": "4201584",
"@ProspectPhone": "+18507743258",
"@RecordingUrl": "",
"@Result": "Conversation (External)",
"@TargetNumber": "+1 800-355-2116",
"@User": "",
"@WaitTime": "",
"@CallId": "B6F952B7-BBFC-4EE2-8257-8178094F8620"
},
{
"@Id": "18894272",
"@AgentId": "11501",
"@CallDuration": "0:00:23",
"@CallOrigin": "Outbound - Manual",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 4:54:39 PM",
"@Campaign": "Internet",
"@ContactId": "4216999",
"@Group": "Brokers",
"@InboundPhone": "",
"@LeadFullName": "***",
"@LeadId": "4216999",
"@ProspectPhone": "+14046418572",
"@RecordingUrl": "",
"@Result": "Voicemail",
"@TargetNumber": "+1 515-762-0005",
"@User": "***, Kalin",
"@WaitTime": "",
"@CallId": "B3BFA673-2D20-4DF5-BD9E-DE249921CAB6"
},
{
"@Id": "18894273",
"@AgentId": "11501",
"@CallDuration": "0:00:27",
"@CallOrigin": "Outbound - Manual",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 4:55:04 PM",
"@Campaign": "R",
"@ContactId": "4216611",
"@Group": "Brokers",
"@InboundPhone": "",
"@LeadFullName": "****",
"@LeadId": "4216611",
"@ProspectPhone": "+18138921483",
"@RecordingUrl": "",
"@Result": "Unknown",
"@TargetNumber": "+1 515-762-0005",
"@User": "****, Kalin",
"@WaitTime": "",
"@CallId": "0D1C5810-76D0-4D45-BDA1-C75A024FFA76"
},
{
"@Id": "18894274",
"@AgentId": "11501",
"@CallDuration": "0:01:26",
"@CallOrigin": "Outbound - Manual",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 5:55:33 AM",
"@Campaign": "R",
"@ContactId": "4172033",
"@Group": "Brokers",
"@InboundPhone": "",
"@LeadFullName": "***",
"@LeadId": "4172033",
"@ProspectPhone": "+18436927191",
"@RecordingUrl": "",
"@Result": "Conversation",
"@TargetNumber": "+1 515-762-0005",
"@User": "***, Kalin",
"@WaitTime": "",
"@CallId": "341C83F0-2297-481E-AB0C-FC8A35440393"
},
{
"@Id": "18894275",
"@AgentId": "11606",
"@CallDuration": "0:00:24",
"@CallOrigin": "Outbound - Manual",
"@CallSegment": "Initial",
"@CallTime": "10/30/2024 5:56:26 AM",
"@Campaign": "RS",
"@ContactId": "4216411",
"@Group": "Brokers",
"@InboundPhone": "",
"@LeadFullName": "***",
"@LeadId": "4216411",
"@ProspectPhone": "+17274099886",
"@RecordingUrl": "",
"@Result": "Unknown",
"@TargetNumber": "+1 515-644-4131",
"@User": "***, Rod",
"@WaitTime": "",
"@CallId": "F3F27ABB-AD66-4233-ADCA-ECD721E122FE"
}
]
And i am filtering it inside a FilterArray action using this action "Apply_to_each", where the Apply to Each include a list of users as follow:-
here is the list of users as a sample which i am iterating over inside Apply_to_each:-
[
{
"Users": ""
},
{
"Users": "**, James"
},
{
"Users": "**, Kalin"
},
{
"Users": "**, Rod"
},
{
"Users": "**, Brock"
}
]
and here is the Filter Array formula:-
and(and(greaterOrEquals(int(split(split(item()?['@CallTime'], ' ')[1], ':')[0]), 4), endsWith(item()?['@CallTime'], 'PM')),
and(less(int(split(split(item()?['@CallTime'], ' ')[1], ':')[0]), 5),
endsWith(item()?['@CallTime'], 'PM')), equals(item()?['@user'], items('Apply_to_each')))
but the formula always return empty array,, any advice?
Categories:
All responses (
Answers (
