Arguments

Name	Description	Default
contactId R
tagId R

SQL Call

exec ActiveCampaign.AssignTag

Http Call

/bsc/activecampaign/assigntag

Output Columns

This call does not return data.

Arguments

Name	Description	Default
companyname R
address R
countryCode R
city
state
zip

SQL Call

exec ActiveCampaign.CreateAddress 'companyname', 'address','US','city','state','zip'
insert into ActiveCampaign.addresses (companyname,address,countryCode,city,state,zip) values ('abc ltd','1 test','US','city','state','zip')

Http Call

/bsc/activecampaign/createaddress

Output Columns

This call does not return data.

Arguments

Name	Description	Default
email R
firstName
lastName
phone

SQL Call

exec ActiveCampaign.CreateContact
insert into from ActiveCampaign.contacts(email,firstName,lastName,phone) values('test@gmail.com','test user','last user','9869339094')

Http Call

/bsc/activecampaign/createcontact

Output Columns

This call does not return data.

Arguments

Name	Description	Default
name R
stringId R
senderUrl R
senderReminder R

SQL Call

exec ActiveCampaign.CreateList 'abc ltd', 'abc-ltd','test.coom','test reminder'
insert into ActiveCampaign.list (name,stringId,senderurl,senderReminder) values ('abc ltd','abc-ltd','test.com','test reminder')

Http Call

/bsc/activecampaign/createlist

Output Columns

This call does not return data.

Arguments

Name	Description	Default
fromname R
fromemail R
reply2 R
subject
preHeaderText

SQL Call

exec ActiveCampaign.CreateMessage 'fromname', 'fromemail','reply2','subject','preHeaderText'
insert into ActiveCampaign.messages (fromname,fromemail,reply2,subject,preHeaderText) values ('abc ltd','abc.gmail.com','def.gmail.com','test','test')

Http Call

/bsc/activecampaign/createmessage

Output Columns

This call does not return data.

Arguments

Name	Description	Default
tag
tagType
description

SQL Call

exec ActiveCampaign.Createtag 'test tag','contact','test tag description'
insert into from ActiveCampaign.tags(tag,tagType,description) values('test tagg','contact','to create test tag')

Http Call

/bsc/activecampaign/createtag

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R

SQL Call

exec ActiveCampaign.DeleteAddress '1'
delete from ActiveCampaign.addresses where id='1'

Http Call

/bsc/activecampaign/deleteaddress

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R

SQL Call

exec ActiveCampaign.DeleteAssignTag '1'

Http Call

/bsc/activecampaign/deleteassigntag

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R

SQL Call

exec ActiveCampaign.DeleteContact '1'
delete from ActiveCampaign.contacts where id='1'

Http Call

/bsc/activecampaign/deletecontact

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R

SQL Call

exec ActiveCampaign.DeleteList '1'
delete from ActiveCampaign.list where id=1

Http Call

/bsc/activecampaign/deletelist

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R

SQL Call

exec ActiveCampaign.DeleteMessage '1'
delete from ActiveCampaign.messages where id='1'

Http Call

/bsc/activecampaign/deletemessage

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R

SQL Call

exec ActiveCampaign.DeleteTag '1'
delete from ActiveCampaign.tags where id='1'

Http Call

/bsc/activecampaign/deletetag

Output Columns

This call does not return data.

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAccounts
select * from ActiveCampaign.accounts

Http Call

/bsc/activecampaign/listaccounts

Output Columns

Int32 id
String name
String accountUrl
DateTime createdTimestamp
DateTime updatedTimestamp

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAllAddresses
select * from ActiveCampaign.addresses where id=1

Http Call

/bsc/activecampaign/listalladdresses

Output Columns

Int32 id
String companyname
String address
String city
String state
String country
String zip

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAllCampaigns
select * from ActiveCampaign.campaigns where id=1

Http Call

/bsc/activecampaign/listallcampaigns

Output Columns

Int32 id
String type
Int32 userid
String name
DateTime cdate
DateTime mdate

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAllContacts
select * from ActiveCampaign.contacts

Http Call

/bsc/activecampaign/listallcontacts

Output Columns

Int32 id
String firstName
String lastName
String email
String phone
DateTime cdate
DateTime adate
DateTime udate
DateTime edate

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAllMessages
select * from ActiveCampaign.messages where id=1

Http Call

/bsc/activecampaign/listallmessages

Output Columns

Int32 id
String fromname
String fromemail
String reply2
String subject
DateTime cdate
DateTime mdate
String preHeaderText
String text
String html

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAllTags
select * from ActiveCampaign.tags

Http Call

/bsc/activecampaign/listalltags

Output Columns

Int32 id
String tagType
String tag
String description
DateTime cdate

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.ListAllTagsOnContact

Http Call

/bsc/activecampaign/listalltagsoncontact

Output Columns

Int32 id
String contactId
String tagId
DateTime cdate

Arguments

Name	Description	Default
topn

SQL Call

exec ActiveCampaign.RetriveAllList
select * from ActiveCampaign.list where id=1

Http Call

/bsc/activecampaign/retrivealllist

Output Columns

Int32 id
String stringid
String name
DateTime cdate
String toName
String senderName
String senderUrl
String senderReminder

Arguments

Name	Description	Default
id R
topn

SQL Call

exec ActiveCampaign.RetriveLinks '1'

Http Call

/bsc/activecampaign/retrivelinks

Output Columns

Int32 id
Int32 campaignid
Int32 messageid
String link
String name
String linkCampaign
String linkMessage

Arguments

Name	Description	Default
id R
companyname R
address R
countryCode R
city
state
zip

SQL Call

exec ActiveCampaign.UpdateAddress '1','test ltd', 'test address','US','city','state','zip'
Update ActiveCampaign.addresses set companyname='test1 ltd',address='test address',countryCode='US',city='cityname',state='statename',zip='zip code' where id='1'

Http Call

/bsc/activecampaign/updateaddress

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R
email R
firstName
lastName
phone

SQL Call

exec ActiveCampaign.UpdateContact
update from ActiveCampaign.contacts set email='test@gmail.com',firstName='test user',lastName='last user',phone='9869339094'

Http Call

/bsc/activecampaign/updatecontact

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R
fromname R
fromemail R
reply2 R
subject
preHeaderText

SQL Call

exec ActiveCampaign.UpdateMessage '1', 'abc ltd', 'abc.gmail.com','def.gmail.com','test message','testing'
udpate ActiveCampaign.messages set fromname='abc ltd',fromemail='abc.gmail.com',reply2='def.gmail.com',subject='test message',preHeaderText='testing' where id='1'

Http Call

/bsc/activecampaign/updatemessage

Output Columns

This call does not return data.

Arguments

Name	Description	Default
id R
tag
tagType
description

SQL Call

exec ActiveCampaign.UpdateTag
update from ActiveCampaign.tags set email='test@gmail.com',firstName='test user',lastName='last user',phone='9869339094'

Http Call

/bsc/activecampaign/updatetag

Output Columns

This call does not return data.