ClickSend is a cloud business messaging provider designed to send and receive SMS, Email, Voice and even post via web app or API.
Data integration: Skyvia supports importing data to and from ClickSend, exporting ClickSend data to CSV files, replicating ClickSend data to relational databases, and synchronizing ClickSend data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support ClickSend backup.
Query: Skyvia Query supports ClickSend.
ClickSend Specific Features and Limitations
- When importing to the Contacts table it is required to specify ListId value and one of the following parameters PhoneNumber, FaxNumber or Email.
- Synchronization is supported for the Contacts table only.
Part of the ClickSend functionality is implemented in Skyvia as stored procedures. Here is the list of them:
call SendAccountVerification(:country, :user_phone, :type)- sends the account for the verification;
call VerifyAccount(:activation_token)- verifies account with the activation token
call ForgotUsername(:email)- if the user forgot the username, this procedure sends the Email with the necessary information.
call ForgotPassword(:username)- if the user forgot the password, this procedure sends the email with a code. This code should be sent as the
:activation_tokenparameter for the
call VerifyForgotPassword(:subaccount_id, :activation_token, :password)- allows setting a new password. Pass the code received as a result of the
call ForgotPassword(:username)procedure. New password is passed as a :password parameter value.
call PurchaseRechargePackage(:package_id)- is used to purchase a recharge package with the specified id
call CopyContactToList(:from_list_id, :contact_id, :to_list_id)- copies the contact from one list to another. The contact obtains a new Id after copying.
call TransferContactToList(:from_list_id, :contact_id, :to_list_id)- moves the contact from one list to another. The Id of the moved contact remains the same after the action is performed.
call RemoveOptedOutContacts(:list_id, :opt_out_list_id)- moves all the opted-out contacts from the specified list to the opt-out list.
call SendEmailVerificationToken(:email_address_id)- verification mail is being sent to the specified email. After that this email address is considered valid and you can use it for campaigns sending.
call VerifyAllowedEmailAddress(:email_address_id, :activation_token)- confirming email using activation token.
call CancelEmailCampaign(:email_campaign_id)- cancels Email campaign sending.
call CancelMMSCampaign(:mms_campaign_id)- cancels MMS campaign sending.
call PurchaseDedicatedNumber(:dedicated_number)- buys the dedicated number.
call CancelScheduledLetter(:message_id)- cancels the scheduled letter.
call CancelScheduledPostcard(:message_id)- cancels the postcard sending.
call ResellerTransferCredit(:client_user_id, :balance, :currency)- to transfer the amount specified as a balance parameter to another account.
call SendSMS(:from, :body, :to)- sends SMS. Parameters from, to and body (sms content) are requied.
call MarkSMSReceiptAsRead(:date_before)- marks all the receipts dated before the specified date as Read.
call MarkInboundSMSAsRead(:date_before)- marks all the sms dated before the data specified in the date_before parameter as read.
call MarkSpecificInboundSMSAsRead(:message_id)- marks all the sms with the specified id as read
call CancelSMS(:message_id)- cancel the sms with specified id sending.
call CancelSMSCampaign(:sms_campaign_id)- cancels sending of the sms campaign with specified id.
call GenerateNewAPIKey(:subaccount_id)- generates new API Key for the specified subaccount. New API Key is returned as a response.
call SendVoiceMessage(:body, :to, :voice, :custom_string, :country)- sends voice message. Specify the required parameters :body, :to, :voice, :custom_string, :country.
call CancelVoiceMessage(:message_id)- cancels sending the voice mail with the specified id.
You can use a call to the stored procedure, for example as a text of the command in the ExecuteCommand action in a Target component of a Data Flow.
Skyvia supports the following DML operations for ClickSend objects:
INSERT, UPDATE, DELETE - ContactLists, Contacts, EmailDeliveryReceiptRules, FaxDeliveryReceiptRules, InboundFaxRules, InboundSMSRules, ReturnAddresses, SMSDeliveryReceiptRules, SMSTemplates, StrippedStringRules, Subaccounts, UserEmailTemplates, VoiceDeliveryReceiptRules
INSERT, UPDATE - EmailCampaigns, MMSCampaigns, ResellerAccounts, SMSCampaigns
INSERT, DELETE - EmailAddresses
INSERT - Accounts, DeliveryIssues, EmailToSMS, InboundSMS, SMSReceipts
Replication with Incremental Updates
Replication with Incremental Updates is supported for the following objects:
Contacts, DeliveryIssues, EmailAddresses, EmailCampaigns, FaxHistory, LettersHistory, MasterEmailTemplates, MMSCampaigns, PostcardsHistory, SMSCampaigns, TransactionalEmailHistory, VoiceHistory
The Contacts table has both CreatedDate and UpdatedDate fields, thus Incremental Replication will consider new records and updated records.
For all other tables only the new records will be considered by the Incremental Replication because all these tables have the CreatedDate field and does not have the UpdatedDate field which is required for tracking the updates.
To establish a connection with ClickSend, you need to use your Username value and an API key. To obtain the credentials, sign-in to ClickSend and click on the key image near your account avatar in the top right corner of your ClickSend page.
Copy the credentials from the appeared banner.
To create connection between Skyvia and ClickSend, do the following:
- Click +NEW and select ClickSend connector.
- Enter username.
- Enter your API Key.
- Click Create Connection.
Supported Actions and Actions Specifics
ClickSend connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
- Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.