How to request billing with NP Kakebarai when the status is updated in JUST.DB by integrating JUST.DB and NP Kakebarai

Integration of JUST.DB and NP Deferred Payment with My App

After copying the template, register JUST.DB and NP Deferred Payment in Yoom's My App as a preliminary step.
※ If you have already registered, please proceed to "Step 1. Setting the App Trigger".

<Procedure>

1. After logging into Yoom, click "My App" → "+ New Connection" in order

2. Search for JUST.DB and NP Deferred Payment from the search window and enter the necessary information for each registration

※Note‍

When registering the NP Deferred Payment app, you need to enter the encoded value of the access token.
For details, please check What is Base64 Encoding.

If JUST.DB and NP Deferred Payment are displayed in the My App list, the preparation is complete!
Let's proceed to the detailed settings right away!

Next, copy the template to My Project and create a flow bot.
If you haven't copied it yet, please copy the flow bot template from below.

1. Hover over the banner and click "View Details"
2. Click "Try this template" on the page you moved to
3. Register for Yoom
※ If you have already completed registration, the login screen will be displayed, so please log in.

‍

Step 1. Set up the App Trigger

First, click the app trigger "When a record is updated".

On the first page, the pre-linked JUST.DB account information will be displayed, so please check it and if there are no issues, click "Next".

On the next page, set up the Webhook event reception.
For details on how to set it up, please refer to this article.

Click "Test" and the obtained information will be reflected as output.
Table identification names and record IDs are displayed by default, but there is other information we want to obtain this time.
In advance, store the necessary information in JUST.DB and add it using JSON PATH.

(List of information you want to obtain)

• Status
• Request ID
• Purchasing Company Name
• Postal Code
• Address
• Phone Number
• Merchant Transaction ID
• Merchant Transaction Order Date
• Transaction Amount
• Item
• Unit Price
• Quantity
• Invoice Issuance Base Date

For details on how to obtain it, please refer to How to Obtain Output Using JSON PATH.
If there are no issues up to this point, the trigger setup is complete by clicking "Save".

Step 2. Command Operation

Next, please click "Command Operation".

In this step, specify branching conditions so that you proceed to the next step only when a specific value is entered in the "Status" field of JUST.DB.
Specify the status obtained with JSON PATH in the "Output" field.
The "Branching Condition" is set by default to the condition that the status is equal to the value of Review OK, but please make changes as necessary.

Step 3. Register Purchasing Company

Next, please click "Register Purchasing Company".

On the first page, the pre-linked account information will be displayed, so please check it and proceed to the next page as it is.

On the second page, set up the API connection. Use the information output from JUST.DB and fill in all the required fields.
Fill in other fields as necessary.
For details on the output, please refer to here.

Click "Test" and if no errors appear, click "Save".

Step 4. Register Transaction

Next, please click "Register Transaction".

On the first page, check the account information and proceed to the next page as it is.
On the second page, set up the API connection. As in the previous step, use the output and fill in all the required fields.

Once you have completed the input, click "Test" and then proceed to the next step by clicking "Save".

Step 5. Request Invoice

Finally, please click "Request Invoice".

On the first page, check the account information and proceed to the next page as it is.

On the second page, set up the settings to request an invoice.
As in the previous step, use the output and fill in all the required fields.

Click "Test" and if no errors appear, click "Save".
If a popup like the one below is displayed, all settings are complete.

In this way, Yoom can be linked without code. Click "Try it" below to copy this template.

‍

Other Automation Examples Using JUST.DB and NP Kakebarai

Yoom offers numerous automation examples using JUST.DB and NP Kakebarai.
It is possible to integrate with various apps, so please refer to the representative examples below.

1. Request Billing with NP Kakebarai When Status is Updated in Airtable

For those who use Airtable as their main database instead of JUST.DB, the following template is recommended.

2. Update the employee management ledger in JUST.DB when employee information is updated in SmartHR

Many people use SmartHR for managing employee information.
By using this integration, information is automatically reflected from SmartHR to JUST.DB, which can improve the efficiency of information management.

3. Grant Garoon or Cybozu Office accounts to employees registered in JUST.DB

This integration is a flow that automates the account issuance process.
In addition to Garoon and Cybozu Office, accounts for kintone and Mailwise can also be automatically issued.

Summary

The above was the procedure for integrating JUST.DB with NP Deferred Payment!
As you can see, Yoom can be used without programming knowledge, making it easy to set up integrations.
Using this integration not only reduces the workload but also seems to lead to a reduction in human errors.
In billing-related procedures where accurate processing is required, reducing errors is a critical issue.
Let's achieve accurate billing processing by minimizing tasks performed manually!

If you want to try automatic integration with Yoom, please register for free from here!