The Kintone API provides programmatic access to your Kintone database, allowing you to manage data such as records, spaces, and apps. With Pipedream, you can harness this API to automate workflows, sync data across different platforms, and trigger actions based on events in Kintone. Whether it's updating records in response to external triggers or pushing data from Kintone to other services, the integrations you can build are versatile and powerful.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
kintone: {
type: "app",
app: "kintone",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.kintone.$auth.subdomain}.kintone.com/k/v1/apps.json`,
headers: {
Authorization: `Bearer ${this.kintone.$auth.oauth_access_token}`,
},
})
},
})
Sync Kintone Records with Google Sheets: Automate the synchronization of data between Kintone and Google Sheets. Whenever a new record is added or updated in Kintone, the workflow triggers and updates the corresponding row in a Google Sheet. This is ideal for sharing data with team members who prefer viewing information in spreadsheet format.
Automated Backup of Kintone Data to Dropbox: Set up a workflow that periodically backs up your Kintone records to Dropbox. This can be a scheduled event that retrieves records from Kintone and saves them as a CSV or JSON file in a designated Dropbox folder, ensuring you have regular backups without manual intervention.
Slack Notifications for New Kintone Records: Create a real-time notification system that alerts a Slack channel whenever a new record is created in Kintone. This keeps your team informed instantly about new entries or requests, fostering quick responses and collaboration.
Kintone uses OAuth authentication. When you connect your Kintone account, Pipedream will open a popup window where you can sign into Kintone and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Kintone API.
Pipedream requests the following authorization scopes when you connect your account:
k:app_record:read
k:app_record:write
k:app_settings:read
k:app_settings:write
k:file:read
k:file:write
GET
https://{{custom_fields.subdomain}}.kintone.com/oauth2/authorization
?
client_id={{custom_fields.client_id}}
&
redirect_uri={{oauth.redirect_uri}}
&
state={{oauth.state}}
&
response_type=code
&
scope={{oauth.space_separated_scopes}}
POST
https://{{custom_fields.subdomain}}.kintone.com/oauth2/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{custom_fields.client_id}}
&
client_secret={{custom_fields.client_secret}}
&
redirect_uri={{oauth.redirect_uri}}
&
grant_type=authorization_code
&
code={{oauth.code}}
POST
https://{{custom_fields.subdomain}}.kintone.com/oauth2/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{custom_fields.client_id}}
&
client_secret={{custom_fields.client_secret}}
&
grant_type=refresh_token
&
refresh_token={{oauth.refresh_token}}