cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1025
Views
0
Helpful
1
Replies

Outbound API'S - which APi would fetch me the fields from dialer_detail table?

plobo
Level 1
Level 1

Hi,

I am using Import API- create to send records to the dialer. I have trouble fetching the call results.

Per the API document, the IMport API-get/list will give me records back with a callresultOverall field, but I need more information than that one field.

Previously, we hit the campaign DB directly to fetch fields from dialer_detail table. I need to fetch the same info through API now.

Below select statement fields is what I am looking for :

select AccountNumber, CampaignID, AgentPeripheralNumber, CallResult, Phone, PeripheralID, PeripheralCallKey, CallStatusZone1, CallStatusZone2, DbDateTime, DateTime, QueryRuleID, DialingMode, DialingListID, RouterCallKeyDay, RouterCallKey

from  DIALER_DETAIL_TABLE

Kindly respond.admin

Thanks.

1 Reply 1

nsaw@cisco.com
Cisco Employee
Cisco Employee

I don't see data of these two tables(Dialer_Detail and Termination_Call_Detail) are directly exposed via any API. However, I see these two API to track status of contacts or campaign:

  1. https://<server>/unifiedconfig/config/campaign/<campaign-id>/import/<import id>
  2. https://<server>/unifiedconfig/config/campaign/<campaign-id>/runtimestats

The response of first API(https://<server>/unifiedconfig/config/campaign/<campaign-id>/import/<import id>) is like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<importContact>

<refURL>/unifiedconfig/config/campaign/5142/import/2</refURL>

<accountNumber>3456</accountNumber>

<callResultOverall>0</callResultOverall>

<callStatus>pending</callStatus>

<firstName>Bob</firstName>

<lastName>Smith</lastName>

<callsMade>0</callsMade>

<importDate>2018-04-23T23:16:42</importDate>

<phone01>

<callResult>0</callResult>

<dstObserved>false</dstObserved>

<gmtOffset>900</gmtOffset>

<number>2225559999</number>

</phone01>

<phone02>

<callResult>0</callResult>

<dstObserved>false</dstObserved>

<gmtOffset>900</gmtOffset>

<number>2225554445</number>

</phone02>

<phone03>

<callResult>0</callResult>

<dstObserved>false</dstObserved>

<gmtOffset>900</gmtOffset>

<number>2225554446</number>

</phone03>

</importContact>

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: