Amazon SQS is a fully managed message queuing service. It offers reliable, highly scalable, reliable messaging and transaction processing that lets you decouple tasks or processes that must communicate.
Zoho Books is cloud-based accounting software that lets you manage your accounts, stay GST compliant, automate company procedures, and collaborate across departments.Zoho Books Integrations
Amazon SQS + Zoho BooksCreate Contact to Zoho Books from New Queue in Amazon SQS Read More...
Amazon SQS + Zoho BooksCreate Sales Invoice to Zoho Books from New Queue in Amazon SQS Read More...
Amazon SQS + Zoho BooksUpdate Contact in Zoho Books when New Queue is created in Amazon SQS Read More...
It's easy to connect Amazon SQS + Zoho Books without coding knowledge. Start creating your own business flow.
Triggers when you add a new queue
Triggers when a new contact is created.
Triggers every time a new credit note is created.
Triggers every time a new estimate is created.
Triggers every time a new item is created.
Triggers every time a new purchase order is created.
Triggers on a new sales invoice in Zoho Books.
Triggers every time a new sales order is created.
Create a new JSON message using data from the source trigger
Create a new message.
Create a new queue
Creates a new bill.
Creates a new contact.
Creates a new item.
Creates a new sales invoice in Zoho Books.
Updates an existing contact.
Updates an existing invoice in Zoho Books.
Amazon SQS (Simple Queue Service. is a web service that allows developers to set up message queues, and process them via applications. Amazon SQS can be integrated with Zoho Books, an online accounting software, for storing data from accounting software. Since the data will be stored in an external application, it will help prevent data loss.
The integration of Amazon SQS and Zoho Books will allow Amazon SQS to retrieve data from the accounting software. Since the data would be retrieved from the accounting software, there is no need to worry about losing any information.
This integration will be done by setting up an Amazon S3 bucket, and configuring it for reading from Zoho Books. The Amazon S3 bucket will then be used to store the data.A1. Setting up an Amazon S3 BucketSet up an Amazon S3 bucket through the configuration interface. There are two ways to add the configuration file for an Amazon S3 bucket; one is to manually create it, and the other is to upload it. For this project, select the latter option. Use the following settings for the bucket. Access Key ID. <Access Key ID> Secret Access Key. <Secret Access Key> Region. <Region> Website Endpoint. <Website Endpoint> Bucket Name. <Bucket Name> Description. <Description> For details about setting up an Amazon S3 bucket, refer to http://docs.aws.amazon.com/AmazonS3/latest/dev/CreatingBucket.html#CreatingBucket.After setting up a bucket, configure it for reading from Zoho Books. To do this, create a new file named 'Credentials', and enter your Access Key ID and Secret Access Key as follows. [Credentials] aws_access_key_id = <Access Key ID> aws_secret_access_key = <Secret Access Key> Then save the file in the folder of 'BucketName'. If you have setup more than one bucket, please copy the Credentials file to each of them.A2. Configure Zoho Books for Amazon S3In Zoho Books, click on the 'Account' tab, followed by 'Setup'. Select 'Preferences', under the 'More Settings' section. From the Preferences page, click on 'S3 Connection'. Fill out the form as follows. URL. <Amazon S3 URL> Bucket Name. <Name of the Bucket>After filling out the form, click on 'Test Connection'. A pop-up window will appear; click on 'OK' if you see "Connection Successful". After seeing "Connection Successful", click on 'Save Settings', followed by clicking on 'Close'.A3. Create an Account in Amazon SQSCreate an account in Amazon SQS by going to https://sqs.us-east-1.amazonaws.com/. This account will act as a queue so that messages can be sent and received between Zoho Books and Amazon SQS.A4. Set up an Application in Amazon SQSClick on the 'Applications' tab once you have logged in to Amazon SQS. Click on 'Create New Application', followed by entering a name for your application, along with a description. Then click on 'Next'. On the next page fill out all of the fields as follows. Application Name. <Application Name> Application Type. AWS CloudFormation Template Web Services Description. <Description> Click on 'Next' to continue on to the next page. On this page, fill out all of the fields as follows. Regional Endpoint. <Endpoint> Protocol. HTTP Signature Version. 2012-08-20 Base64-Encoded Signature. <Base64 Encoded Signature> Click on 'Create New Application' to create your application. The next step is to get the credentials for your application by clicking on your application name. Once you are on the configuration page for your app, go to the 'Credentials' tab, and click on 'Show X509 Certificate'. Copy the 'Access Key ID' and 'Secret Access Key' into a text file named 'Credentials'. Save this file in your bucket's folder. To view your saved credentials, simply go back to your application configuration page, and click on 'Credentials'. A5. Set up a Queue in Amazon SQSClick on the 'Queues' tab once you have logged in to Amazon SQS. Click on 'Create New Queue', followed by entering a name for your queue, along with a description for it. Then click on 'Next'. On the next page fill out all of the fields as follows. Queue Name. <Queue Name> Applications. Choose your application from the list Reserved Capacity Units. 1 Message Retention Period (Days. 100 Click on 'Next' to continue on to the next page. On this page, fill out all of the fields as follows. Queue Protocol. HTTP Message Format. JSON Check I am a bot if you are not a human Reset Form Click on 'Create New Queue' to create your queue. A6. Send Data to Amazon SQS via Zoho BooksThere are two ways that data can be sent to Amazon SQS; one is using a predefined format such as XML or JSON, while the other is using PHP serialization function. In this project, PHP serialize function is used to send data to Amazon SQS because it is easier than using XML or JSON format. Additionally, PHP serialize function is used because it has been supported since Zoho Books version 3.4.8 onwards. To use PHP serialize function in sending data to Amazon SQS using Zoho Books, simply add the following code into PHP code before sending data to Zoho Books database (replace <Access Key ID>, <Access Key Secret>, & <Secret Access Key> with your actual credentials. $data = serialize($row); $fields = array("headers" => array("Content-Type" => "application/x-www-form-urlencoded")); $fields = "Method"; $fields = "body"; $fields = $data; $fields = "Signature"; $fields = base64_encode($this->dsa->sign($fields)); $header = $fields; $fields = null; unset($data); This code should be added before calling Zoho Books database query function (which is usually done at the beginning of PHP script. When data is sent using PHP serialize function, it will automatically convert any object into string and send it as part of POST request body using HTTP method POST . Fetching data from Amazon SQS can also be done in two ways; one is using XML or JSON format which can be easily converted into PHP array or object respectively, while the other is using PHP function dsa->decrypt(. . Since PHP function dsa->decrypt(. can only decrypt base64 encoded cipher text into plain text when there is no padding applied, we need to remove padding before decrypting data using PHP dsa->decrypt(. . Padding can be removed by applying RFC5652 padding removal algorithm which was implemented in dsa->pad_ok(. function provided by OpenSSL library . Refer to tls-ciphersuites sample program provided by OpenSSL library at http://www.openssl.org/docs/crypto/buffer-ciphers.html#BIO_new_crypto_buffer for how to apply padding removal algorithm using PHP dsa->pad_ok(. function . A7. Sending Data Using PHP Serialize FunctionTo send data using PHP serialize function, first need to prepare a header containing method and body . Then prepare a new serialized string by converting any object into string using PHP serialize function (see above. Finally, base64 encode both string prepared earlier using base64_encode(. , and concatenate them together. This new string will now be converted into new header containing method , body , signature , and base64 encoded signature . The new header will also contain padding removed data in its body field by converting it into string before base64 encoding it again using base64_encode(. . The new header will then be sent along with new body which will only contain new line characters ('n'. To send a string containing new line characters ('n'. in body field of header , simply add PHP function "r
" into body field of header . Note that spacing after "For example, if we want to send a string containing new line characters ('n'), we can replace line A7 with following code. header(array("
The process to integrate Amazon SQS and Zoho Books may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick solution to help you automate your workflows. Click on the button below to begin.