GET Inbound/Outbound calls

[jmacias]

Hi, everyone

I want to ask about how can get the Inbound/Outbound calls because i see that in the APP Purecloud i can create a detail report with this mark. I have used the next query but the result is empty:

{"interval": "2018-11-18T23:00:00.000Z/2018-11-19T23:00:00.000Z",
"groupBy": ["queueId"],
"metrics": ["tTalkComplete","tTalk","tNotResponding","tIvr","tHeldComplete","tHeld","tHandle","tDialing","tContacting","tAnswered","tAcw","tAcd","tAbandon","nTransferred","nOutboundConnected","nOutboundAttempted","nOutboundAbandoned","nOutbound","nOffered","nConsultTransferred","nConsult","nOutbound"],
"filter" :{

		     "type": "and",
		     "predicates":[
			          {
                        "type": "dimension",
				    	"dimension" : "queueId",
                        "operator": "matches",
				    	"value": "10813848-2669-4e28-9b30-e01b95d71f8d",
				  },
                  {
                        "type": "dimension",
                        "dimension": "direction",
                        "operator": "matches",
				   		 "value": "inbound/outbound",
				  }
				  ]

	 },
    "granularity":"PT1H",
    "flattenMultivaluedDimensions": "true"}

Any suggest? Thanks for your answer

[tim.smith]

Use the Developer Tools Analytics Query Builder to design and test your queries. If there is no data that matches your filters in the interval specified, no data will be returned.

Edit: inbound/outbound isn't a valid value. Remove your predicates and choose values found in the unfiltered result set

[jmacias]

Hi tim

thanks for your answer but i want to expand the question. is correct the syntax "value": "inbound/outbound" for search these calls?. Althrough i was checking the detail report in interactions option and i found this:

and i test this query in developer tools where the result continue empty:

{
 "interval": "2019-03-12T05:00:00.000Z/2019-03-17T05:00:00.000Z",
 "granularity": "PT1H",
 "groupBy": [
  "queueId"
 ],
 "filter": {
  "type": "and",
  "predicates": [
   {
    "type": "dimension",
    "dimension": "direction",
    "operator": "matches",
    "value": "inbound/outbound"
   },
   {
    "type": "dimension",
    "dimension": "queueId",
    "operator": "matches",
    "value": "10813848-2669-4e28-9b30-e01b95d71f8d"
   }
  ]
 },
 "views": [],
 "metrics": [
  "nOffered",
  "tTalk",
  "tHandle",
  "tHeld"
 ]
}

EDIT: if the value "inbound/outbound" is invalided, How do i to get the "inbound/outbound" calls for query?

Thanks for your help.

[tim.smith]

The values for filters must be values that are found in the results. If you look through the result data, you'll see "direction": "inbound" or "direction": "outbound". You can use either of those values, but you cannot make up your own values or syntax.

The reports displayed in the UI may contain calculated, aggregated, and translated values. The direction column is one of those.

[jmacias]

Hi Tim

Thanks for your answer, but i continue to confuse about how can i get "inbound/outbound" calls? Do i need to translate some fields? use other different function API aggregate?. I'm using the function post_analytics_conversations_aggregates_query.

Best regards

[tim.smith]

Create a filter with type or and two predicates for direction; one for inbound, one for outbound.