# CJ올리브네트웍스 연동

## 준비 및 설정

#### 사전 준비 사항

핑거푸시 Agent와 CJAgent 연동 전에 각각 개별 에이전트가 정상 동작됨을 확인 후에 연동을 해야 합니다.

#### 푸시 환경 설정 파일에서 CJAgent 연결 설정

* 설치 경로/bin/ agentDistServerConfig.xml 파일 내의 config.database값이 mariadb인 경우 agentDistServerConfig\_mariadb.xml파일에서 설정하면 됩니다.
* 설치 경로/bin/ agentDistServerConfig\_{database}.xml 파일에서, CJAgent의 데이타 베이스 설정 <{database}\_sms1><{database}\_kakao1>블록이 CJAgent 설정하는 부분입니다.

```xml
<database>
    <kindofdb> {database} </kindofdb><!—oracle, mssql, mysql, mariadb중 하나 -->
        <{database}_sms1><!-- 문자 발송 -->
            <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
            <dbname>dbname</dbname>
            <url>jdbc:sqlserver://ip:port;databaseName=dbname;</url>
            <minidle>5</minidle>
            <maxactive>30</maxactive>
            <username>username</username>
            <password>password</password>
            <poolname>fpagents</poolname>
            <validationQuery>select 1 </validationQuery>
	    <transforTosms>
		  <mode>CAMP, STOS,STOE </mode>
		  <queuetable sms-msg="SMS_MSG " mms-msg="MMS_MSG"/>
	    </transforTosms>
        </{database}_sms1>
        <{database}_kakao1><!-- 카카오 발송(알림톡, 친구톡) -->
            <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
            <dbname>dbname</dbname>
            <url>jdbc:sqlserver://ip:port;databaseName=dbname;</url>
            <minidle>5</minidle>
            <maxactive>30</maxactive>
            <username>username</username>
            <password>password</password>
            <poolname>fpagents</poolname>
	    <validationQuery>select 1 </validationQuery>
	    <transforTokakao>
		  <mode>CAMP, STOS,STOE </mode>
		  <queuetable kko-msg="KKO_MSG" kkf-msg="KKF_MSG "/>
	    </transforTokakao>
        </{database}_kakao1>
</database>

```

#### 알림톡, 문자 전환 발송 환경 설정

설치 경로/bin/ agentDistServerConfig.xml 파일 내 config.push.transfertotext, config.push.transfertokakao 항목을 아래와 같이 설정(기본 셋팅)합니다.&#x20;

만일 전환 발송을 중단하려면, activity를 false 처리하고 에이전트를 재시작하면 푸시 발송은 유지하고 전환 발송만 중단됩니다.&#x20;

설정 완료 후 푸시 에이전트를 재시작합니다.

```xml
<?xml version= "1.0" encoding= "UTF-8" ?>
<config>
    <push>
        <transfertotext 
        id="cj" 
        activity="true" 
        transfer_code="2404,2403,2402,2401" />
       <transfertokakao  
    	id="cj" 
       	activity="true" 
       	transfer_code="2404,2403,2402,2401" />
    </push>
</config>
```

#### &#x20;푸시 실패 후 전환 발송 프로세스

1\) 푸시 에이전트 - 푸시 발송(단말기로 푸시 발송) – kk로 시작하는 컬럼에 데이터 입력

2\) 푸시 에이전트 - 푸시 실패한 단말기의 데이터(queue테이블에서 kk로 시작하는 컬럼)를 CJ의 msg 테이블에 insert

3\) CJ에이전트 - 친구톡/알림톡 발송

4\) CJ에이전트 - 친구톡/알림톡 실패한 단말기의 데이터를 CJ의 sms\_msg, mms\_msg테이블에 insert

* failedtype – 푸시 발송 후 실패 시 전환되는 메시지 값(kko, kkf, sms, lms, mms)
* kko\_failed\_type – 알림톡 또는 친구톡 실패 시 전환되는 메시지 값(sms, lms, mms)
* 위 두 컬럼을 조건에 맞게 설정해야 전환 발송이 가능합니다.

## 테스트 샘플&#x20;

#### 푸시⇨SMS 전환 발송 테스트 샘플

{% code title="Mysql, Mariadb" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’,캠페인코드,’수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지)
```

{% endcode %}

{% code title="Oracle" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL , ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx , appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->SMS’, ‘식별자’,  ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지”)
```

{% endcode %}

{% code title="Mssql" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’,캠페인코드,’수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
```

{% endcode %}

{% code title="PostgreSQL" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ‘Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP, ‘푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_AUTOQUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP, ‘푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
```

{% endcode %}

#### 푸시⇨LMS/MMS 전환 발송 테스트 샘플

{% code title="Mysql, Mariadb" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키 ‘, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->LMS/MMS ‘, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ’랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)
```

{% endcode %}

{% code title="Oracle" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL , ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’. ‘LMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx , appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->LMS/MMS’, ‘식별자’,  ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘MMS’, ‘메시지제목’, ‘전환메시지’)
```

{% endcode %}

{% code title="Mssql" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시-> 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)
```

{% endcode %}

{% code title="PostgreSQL" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMs메시지제목’, ‘LMS메시지’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMs메시지제목’, ‘LMs메시지’)
```

{% endcode %}

#### 푸시⇨친구톡 전환 발송 테스트 샘플

{% hint style="info" %} <mark style="color:blue;">failedtype=KKF로 설정되면 푸시 실패 시 친구톡으로 전환됩니다.</mark>
{% endhint %}

{% code title="Mysql, Mariadb" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
```

{% endcode %}

{% code title="Oracle " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
```

{% endcode %}

{% code title="MSSQL " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= getdate() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(), ‘푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
```

{% endcode %}

{% code title="PostgreSQL" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
```

{% endcode %}

#### 푸시⇨친구톡⇨SMS/LMS/MMS 전환 발송 테스트 샘플

{% hint style="info" %} <mark style="color:blue;">failedtype=KKF, kko\_failed\_type=SMS/LMS/MMS로 설정되면</mark> \ <mark style="color:blue;">푸시 실패⇨친구톡 실패⇨문자메시지로 전환됩니다.</mark>
{% endhint %}

{% code title="Mysql, Mariadb " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

{% code title="Oracle failedtype=KKF, kko\_failed\_type=SMS/LMS/MMS로 설정되면 푸시실패⇨친구톡실패⇨문자메시지로 전환됨" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

{% code title="MSSQL " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= getdate() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(), ‘푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

{% code title="PostgreSQL " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

#### 푸시⇨알림톡 전환 발송 테스트 샘플

{% hint style="info" %} <mark style="color:blue;">failedtype=KKO로 설정되면 푸시 실패 시 알림톡으로 전환됩니다.</mark>
{% endhint %}

{% code title="Mysql, Mariadb " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’, ‘알림톡템플릿코드’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
```

{% endcode %}

{% code title="Oracle " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
```

{% endcode %}

{% code title="MSSQL  " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=getdate() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
```

{% endcode %}

{% code title="PostgreSQL " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘친구톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
```

{% endcode %}

#### 푸시⇨알림톡⇨SMS/LMS/MMS 전환 발송 테스트 샘플

{% hint style="info" %} <mark style="color:blue;">failedtype=KKO, kko\_failed\_type=SMS/LMS/MMS로 설정되면</mark>&#x20;

<mark style="color:blue;">푸시 실패⇨알림톡 실패⇨문자메시지로 전환됩니다.</mark>
{% endhint %}

{% code title="Mysql, Mariadb " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’, ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

{% code title="Oracle failedtype=KKO, kko\_failed\_type=SMS/LMS/MMS로 설정되면 푸시실패⇨알림톡실패⇨문자메시지로 전환됨" %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

{% code title="MSSQL  " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=getdate() WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
```

{% endcode %}

{% code title="PostgreSQL " %}

```sql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)

INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘친구톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드

-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
```

{% endcode %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://developers.fingerpush.com/app-push/agent/cj.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.