使用SQL Server从模板发送大量语音
使用SQL Server向一组座机或手机发送批量语音消息(文本到语音)
SQL Server : API文档
使用SQL Server从模板发送大量语音
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'voice';
DECLARE @method varchar(500) = 'sendvoicetogroupfromtemplate';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @countrycode varchar(500) = '34';
DECLARE @idgroup varchar(500) = '1';
DECLARE @idtemplate varchar(500) = '1000';
DECLARE @scheduledatetime varchar(500) = '';
DECLARE @language varchar(500) = 'en';
DECLARE @voice varchar(500) = 'Joanna';
DECLARE @output varchar(500) = '';
DECLARE @url varchar(255) = 'https://www.afilnet.com/api/http/?class='+@class+'&method='+@method+'&user='+@user+'&password='+@password+'&countrycode='+@countrycode+'&idgroup='+@idgroup+'&idtemplate='+@idtemplate+'&scheduledatetime='+@scheduledatetime+'&language='+@language+'&voice='+@voice+'&output='+@output;
DECLARE @win int
DECLARE @hr int
DECLARE @text varchar(8000)
EXEC @hr=sp_OACreate 'WinHttp.WinHttpRequest.5.1',@win OUT
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OAMethod @win, 'Open',NULL,'GET',@url,'false'
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OAMethod @win,'Send'
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OAGetProperty @win,'ResponseText',@text OUTPUT
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
EXEC @hr=sp_OADestroy @win
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win
参数 | 描述 | 必修/可选 |
---|---|---|
class=voice | 要求的课程:要求的课程 | 必修 |
method=sendvoicetogroupfromtemplate | 请求的类方法:发出请求的类的方法 | 必修 |
user | 您的Afilnet帐户的用户和电子邮件 | 必修 |
password | 您的Afilnet帐户的密码 | 必修 |
countrycode | voice.sendvoicetogroupfromtemplate_countrycode | 必修 |
idgroup | 组标识符,包含将语音呼叫发送到的联系人 | 必修 |
idtemplate | 包含语音呼叫将播放的消息的模板的标识符 | 必修 |
scheduledatetime | 装运日期和时间,以yyyy-mm-dd hh:mm:ss格式 | 可选的 |
language | 语音通话将使用的语言,请查看所附表格以查看可用值 | 可选的 |
voice | 可以进行语音通话的语音,请查看所附表格以查看可用值 | 可选的 |
output | 结果的输出格式 | 可选的 |
发出请求时,您将收到以下字段:
- status
-
结果(如果status = success),您将在此处收到以下值:
- id
- count
- credits
-
destinations
- messageid
- destination
- 错误(如果status = error),在这里您将收到错误代码
下面列出了可能的错误代码
码 | 描述 |
---|---|
MISSING_USER | 不包括用户或电子邮件 |
MISSING_PASSWORD | 不包含密码 |
MISSING_CLASS | 不包括课程 |
MISSING_METHOD | 不包括方法 |
MISSING_COMPULSORY_PARAM | 不包括强制参数 |
INCORRECT_USER_PASSWORD | 用户或密码错误 |
INCORRECT_CLASS | 班级不正确 |
INCORRECT_METHOD | 方法不正确 |
NOT_ACCESS_TO_GROUP | 不允许您进入指定的组 |
NO_CREDITS | 您的余额不足 |
参数:
- class : voice
- method : sendvoicetogroupfromtemplate
- user : user
- password : password
- countrycode : 34
- idgroup : 1
- idtemplate : 1000
- scheduledatetime :
- language : en
- voice : Joanna
- output :
请求:
https://www.afilnet.com/api/http/?class=voice&method=sendvoicetogroupfromtemplate&user=user&password=password&countrycode=34&idgroup=1&idtemplate=1000&scheduledatetime=&language=en&voice=Joanna&output=
附件:可用语音通话的语言和语音列表
在本附件中,您将找到发送语音呼叫消息时可以使用的所有语言和语音组合
语言 (language) | 性别 | 名称 (voice) |
---|---|---|
ar | female | Hoda |
ar | male | Naayf |
ar | male | Tarik |
ar | female | Zeina |
ar | female | Aisha |
ar | male | Farooq |
ar | male | Hussein |
ar | female | Amal |
bg | male | Ivan |
bn | female | Sushmita |
bn | male | Sayan |
ca | female | Conchita |
ca | female | Herena |
ca | female | Montserrat |
cs | male | Jakub |
da | female | Naja |
da | female | Helle |
da | male | Mads |
de | male | Hans |
de | female | Hedda |
de | female | Marlene |
de | male | Stefan |
de | female | Angela |
de | female | Vicki |
de-at | male | Michael |
de-ch | male | Karsten |
el | male | Stefanos |
el | female | Afroditi |
el | female | Sophia |
en | female | Jessica |
en | male | Joey |
en | female | Joanna |
en | female | Jane |
en | female | Ivy |
en | male | Guy |
en | male | Benjamin |
en | female | Kimberly |
en | male | Matthew |
en | female | Kendra |
en | female | Salli |
en | female | Zira |
en | male | Justin |
en-au | male | Russell |
en-au | female | Catherine |
en-au | female | Hayley |
en-au | female | Nicole |
en-ca | female | Alice |
en-ca | female | Heather |
en-gb | female | Rosie |
en-gb | female | Hazel |
en-gb | male | George |
en-gb | male | Brian |
en-gb | female | Amy |
en-gb | female | Emma |
en-gb-wls | male | Geraint |
en-ie | male | Sean |
en-in | female | Heera |
en-in | male | Ravi |
en-in | female | Raveena |
en-in | female | Priya |
en-in | female | Aditi |
es | male | Miguel |
es | female | Penelope |
es | female | Lupe |
es | male | Pablo |
es | male | Enrique |
es | female | Laura |
es | female | Linda |
es-ar | male | Diego |
es-cl | female | Francisca |
es-es | female | Lola |
es-mx | male | Raul |
es-mx | female | Mia |
es-mx | female | Hilda |
fi | female | Heidi |
fi | female | Milla |
fi | female | Evelin |
fr | female | Juliette |
fr | female | Celine |
fr | male | Mathieu |
fr | female | Lea |
fr | female | Hortense |
fr | male | Picart |
fr-ca | female | Chantal |
fr-ca | female | Harmonie |
fr-ca | female | Caroline |
fr-ch | male | Guillaume |
gu | male | Dinesh |
gu | female | Leela |
he | male | Asaf |
hi | female | Aadita |
hi | female | Kalpana |
hi | male | Hemant |
hr | male | Matej |
hu | male | Szabolcs |
id | male | Andika |
id | male | Arif |
id | female | Indah |
id | male | Reza |
id | female | Nurul |
is | male | Karl |
is | female | Dora |
it | male | Giorgio |
it | male | Cosimo |
it | male | Carla |
it | female | Bianca |
it | female | Lucia |
it | female | Gianna |
ja | female | Mizuki |
ja | male | Ichiro |
ja | female | Ayumi |
ja | male | Takumi |
ja | female | Haruka |
kn | female | Namratha |
kn | male | Shashank |
ko | female | Jina |
ko | female | Sumi |
ko | female | Yumi |
ko | female | Seoyeon |
ko | female | Heami |
ko | male | Himchan |
ko | male | Minho |
ml | female | Kirti |
ml | male | Vishnu |
ms | male | Rizwan |
nl | male | Ruben |
nl | female | Lotte |
nl | female | Hanna |
no | female | Hulda |
no | female | Liv |
pl | female | Paulina |
pl | female | Maja |
pl | male | Jan |
pl | male | Jacek |
pl | female | Ewa |
pt-br | female | Vitoria |
pt-br | male | Ricardo |
pt-br | female | Heloisa |
pt-br | male | Daniel |
pt-br | female | Camila |
pt-pt | male | Jeraldo |
pt-pt | female | Jacinda |
pt-pt | male | Henriques |
pt-pt | female | Amalia |
pt-pt | female | Abrielle |
pt-pt | female | Ines |
pt-pt | female | Helia |
pt-pt | male | Cristiano |
ro | female | Carmen |
ro | male | Andrei |
ru | female | Irina |
ru | female | Ekaterina |
ru | male | Maxim |
ru | male | Pavel |
ru | female | Tatyana |
sk | male | Filip |
sl | male | Lado |
sv | female | Astrid |
sv | female | Hedvig |
ta | male | Valluvar |
ta | male | Ganesh |
ta | female | Shruti |
te | male | Vijay |
te | female | Samantha |
te | female | Chitra |
th | male | Pattara |
th | female | Somsi |
tr | female | Filiz |
tr | female | Seda |
vi | female | Lien |
vi | male | Quan |
vi | male | Thao |
vi | female | Mai |
vi | male | An |
wls | female | Gwyneth |
zh-cn | female | Akemi |
zh-cn | male | Wang |
zh-cn | female | Lin |
zh-cn | female | Huihui |
zh-cn | male | Zhang |
zh-cn | female | Liu |
zh-cn | male | Huang |
zh-cn | male | Chen |
zh-cn | female | Zhiyu |
zh-cn | female | Yaoyao |
zh-cn | female | Lily |
zh-cn | male | Kangkang |
zh-tw | female | Hanhan |
zh-tw | female | Yating |
zh-tw | male | Zhiwei |