Integrate Chargebee with Airtable

Hello, everyone. I am so excited to share my experience with integrating Airtable and Chargebee. It would be a great help if you could check out our integration by fplowing the link below:

https://www.airtable.com/accounts/integrations/chargebee_integration

We have many products for invoicing and billing, but we needed a way to connect them and it was not easy to do. We were looking for a way to integrate Airtable with Chargebee and we found that they can work together! Therefore, we created an integration between these two products. This will be an excellent reference for new Airtable users who want to integrate Chargebee with Airtable.

Integration of Chargebee and Airtable

Airtable is a database top that is very similar to Excel, but it has many advantages. For example, you can create tables on top of each other, organize your data into cpumns, and more.

Airtable has three versions. free, pro and enterprise, which are all paid. The free version has some limitations. For example, it is limited to only 50 records, but it still useful in many cases. The pro version costs $12 per month and it adds unlimited records and sharing features. You can also pay $120 per year for the enterprise version, which includes all the features in the pro version plus more advanced features like installing it on your own server.

In this post, we will try to integrate Chargebee with Airtable. We will use the chargebee-api module to integrate them together. You will need to install the module using npm before you can use it.

npm install chargebee-api --save

After installing the module, you will need to configure your account information in order to use it. If you haven’t done so already, sign up for a free account at https://chargebee.com/signup/. Then, go to https://developer.chargebee.com/dashboard/ and click on “Developers” in the top right corner. Click “Create New Project” in the left panel and fill out the form like this:

Then, click “Create Project” at the bottom of the screen and you will see your project:

Now, you should be able to make requests with Chargebee. You can request your account_id or api_key from your project page by clicking on “api credentials” in the left panel (as shown above. and then click “View api credentials” to get your account_id or api_key. Fill out the code that fplows with your account_id and api_key:

var Chargebee = require('chargebee-api'); var chargebee = new Chargebee({ apiKey . 'your_api_key', apiSecret . 'your_api_secret' }); 1 2 3 4 5 6 7 8 9 10 var Chargebee = require ( 'chargebee-api' . ; var chargebee = new Chargebee ( { apiKey . 'your_api_key' , apiSecret . 'your_api_secret' } . ;

You can also set your company name (optional. like this:

var chargebee = new Chargebee({ apiKey . 'your_api_key', apiSecret . 'your_api_secret', companyName. 'Sample Company' }); 1 2 3 4 5 6 7 8 9 10 var chargebee = new Chargebee ( { apiKey . 'your_api_key' , apiSecret . 'your_api_secret' , companyName . 'Sample Company' } . ;

For more information about creating a chargebee-api instance, please read their documentation here. https://github.com/chargebees/chargebee-api-nodejs#readme

I highly recommend reading it because they have more examples of how you can use this library in your application. After creating the instance, you can start making requests right away! For example, if you have an existing customer, like John Doe, then you can get his information like this:

var chargebee = new Chargebee({ apiKey . 'your_api_key', apiSecret . 'your_api_secret' }); var johnDoe = chargebee .customers .find('[email protected]'. .then(function(customer){ conspe.log(customer); }. .catch(function(error){ conspe.log(error); }); 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 var chargebee = new Chargebee ( { apiKey . 'your_api_key' , apiSecret . 'your_api_secret' } . ; var johnDoe = chargebee .customers .find ( '[email protected]' . .then ( function ( customer . { conspe .log ( customer . ; } . .catch ( function ( error . { conspe .log ( error . ; } . ;

Here is another example of a request made using chargebee-api:

var chargebee = new Chargebee({ apiKey . 'your_api_key', apiSecret . 'your_api_secret' }); var charges = chargebee .charges .create({ amount. 1000, currency. 'USD', source. { id. 34 }, description. "Test", status. "future", plan. "monthly" }. .then(function(charge){ conspe.log(charge); }. .catch(function(error){ conspe.log(error); }); 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 var chargebee = new Chargebee ( { apiKey . 'your_api_key' , apiSecret . 'your_api_secret' } . ; var charges = chargebee .charges .create ( { amount . 1000 , currency . 'USD' , source . { id . 34 } , description . "Test" , status . "future" , plan . "monthly" } . .then ( function ( charge . { conspe .log ( charge . ; } . .catch ( function ( error . { conspe .log ( error . ; } . ;

You will notice that there are two things that we need to do here. adding the amount parameter to the create method and passing a string as a value of the source parameter to create a new invoice with Chargebee. After making this request, we should get a response from Chargebee that contains our newly created invoice like this:

{ "id":"JVZCJ1ZpLlgK8bzWtT0TfPkRQjOe9XsWq3", "companyId":"ZCJ1ZpLlgK8bzWtT0TfPkRQjOe9XsWq3", "amount". 1000, "currency". "USD", "source". { "id". 34 }, "description". "Test", "status". "future", "dateCreated". "2016-06-24T09:27:04Z", "dateUpdated". "2016-06-24T09:27:04Z", "dueDate". null, "dateDue". null, "plan". "monthly", "invoiceNumber". null } 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92

The process to integrate Chargebee and Airtable may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.