Resources
| Data Source Type | REST/URL |
| Authentication: |
API Key |
| Sample Query |
For all Stax Bill customers:
|
| API Documentation | Stax Bill API documentation |
Step-by-Step
Creating a data source using Stax Bill
To create a data source using Stax Bill, you need to accomplish three tasks:
- Start the data source creation process.
- Write a query and enter it in Klipfolio.
- Authenticate with Stax Bill.
Step 1. Start the data source creation process
To create a data source using Stax Bill, go to the Service Connector page in Klipfolio and select Stax Bill.
Step 2: Write a query and enter it in Klipfolio
Refer to the Stax Bill API documentation to learn more about writing a query. Here are a few sample queries to help you get started:
For all Stax Bill customers:
https://secure.fusebill.com/v1/customers
For plan frequency:
https://secure.fusebill.com//v1/plans?Query=status:Active
For active customers:
https://secure.fusebill.com/v1/customers?Query=status:Active
Once you have entered a query in Klipfolio,
- At Data Format, select JSON from the drop-down list.
- At Method, select GET.
Step 3: Authenticate with Stax Bill
You are provided with an API Key when you sign up with Stax Bill. If you do not have an API Key, contact Stax Bill and they will be happy to provide you with a key.
To enter your Stax Bill API key in Klipfolio,
- Select Query Parameters.
- At Name, type Authorization.
- At Value, enter the API Key in the following format: Basic <your-API-Key>
- Under Type, select Header from the drop-down list.
- Click Get data.
Note: In addition to your unmodelled data source, you can create a modelled version of your data source at this stage. To create a modelled data source, ensure that the checkbox next to Model this data source is selected before clicking Continue.
To learn more about creating a modelled data source, click here.