← Airtable + Lucca integrations

Update User Info with Lucca API on New or Modified Records (Instant) from Airtable API

Pipedream makes it easy to connect APIs for Lucca, Airtable and 2,900+ other apps remarkably fast.

Trigger workflow on
New or Modified Records (Instant) from the Airtable API
Next, do this
Update User Info with the Lucca API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

This integration creates a workflow with a Airtable trigger and Lucca action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the New or Modified Records (Instant) trigger
    1. Connect your Airtable account
    2. Select a Base
    3. Optional- Select a Table
    4. Optional- Select a View
    5. Optional- Select one or more From Sources
    6. Optional- Select one or more Watch Data In Field Ids
  3. Configure the Update User Info action
    1. Connect your Lucca account
    2. Select a User ID
    3. Optional- Configure First Name
    4. Optional- Configure Last Name
    5. Optional- Configure Email
    6. Optional- Configure Login
    7. Optional- Select a Legal Entity ID
    8. Optional- Configure Calendar ID
    9. Optional- Configure Employee Number
    10. Optional- Configure Birth Date
    11. Optional- Configure Address
    12. Optional- Configure Bank Name
    13. Optional- Configure Direct Line
    14. Optional- Configure Gender
    15. Optional- Select a Nationality
    16. Optional- Configure Personal Email
    17. Optional- Configure Personal Mobile
    18. Optional- Configure Professional Mobile
    19. Optional- Configure Quote
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Emit new event for each new or modified record in a table or view
Version:1.0.4
Key:airtable_oauth-new-or-modified-records

Airtable Overview

Airtable (OAuth) API on Pipedream allows you to manipulate and leverage your Airtable data in a myriad of powerful ways. Sync data between Airtable and other apps, trigger workflows on updates, or process bulk data operations asynchronously. By using Airtable's structured databases with Pipedream's serverless platform, you can craft custom automation solutions, integrate with other services seamlessly, and streamline complex data processes.

Trigger Code

import common from "../common/common-webhook-record.mjs"; import airtable from "../../airtable_oauth.app.mjs"; export default { ...common, name: "New or Modified Records (Instant)", key: "airtable_oauth-new-or-modified-records", description: "Emit new event for each new or modified record in a table or view", version: "1.0.4", type: "source", dedupe: "unique", methods: { ...common.methods, getChangeTypes() { return [ "add", "update", ]; }, }, props: { ...common.props, watchDataInFieldIds: { propDefinition: [ airtable, "sortFieldId", (c) => ({ baseId: c.baseId, tableId: c.tableId, }), ], type: "string[]", label: "Watch Data In Field Ids", description: "Only emit events for updates that modify values in cells in these fields. If omitted, all fields within the table/view/base are watched", }, }, }; 

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
AirtableairtableappThis component uses the Airtable app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
BasebaseIdstringSelect a value from the drop down menu.
TabletableIdstringSelect a value from the drop down menu.
ViewviewIdstringSelect a value from the drop down menu.
From SourcesfromSourcesstring[]Select a value from the drop down menu:{ "value": "client", "label": "Changes generated by a user through the web or mobile clients" }{ "value": "publicApi", "label": "Changes generated through the Airtable API" }{ "value": "formSubmission", "label": "Changes generated when a form view is submitted" }{ "value": "formPageSubmission", "label": "Changes generated when an interface form builder page, form layout page, or record creation button page is submitted" }{ "value": "automation", "label": "Changes generated through an automation action" }{ "value": "system", "label": "Changes generated by system events, such as processing time function formulas" }{ "value": "sync", "label": "Changes generated through Airtable Sync" }{ "value": "anonymousUser", "label": "Changes generated by an anonymous user" }{ "value": "unknown", "label": "Unknown" }
Watch Data In Field IdswatchDataInFieldIdsstring[]Select a value from the drop down menu.

Trigger Authentication

Airtable uses OAuth authentication. When you connect your Airtable account, Pipedream will open a popup window where you can sign into Airtable and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Airtable API.

Pipedream requests the following authorization scopes when you connect your account:

data.records:readdata.records:writedata.recordComments:readdata.recordComments:writeschema.bases:readschema.bases:writewebhook:manageuser.email:read

About Airtable

Airtable is a low-code platform to build next-gen apps. Move beyond rigid tools, operationalize your critical data, and reimagine workflows with AI.

Action

Description:Update profile or HR information for an existing user. [See the documentation](https://developers.lucca.fr/api-reference/legacy/directory/update-a-user-by-id)
Version:0.0.2
Key:lucca-update-user-info

Action Code

import { ConfigurationError } from "@pipedream/platform"; import lucca from "../../lucca.app.mjs"; export default { key: "lucca-update-user-info", name: "Update User Info", description: "Update profile or HR information for an existing user. [See the documentation](https://developers.lucca.fr/api-reference/legacy/directory/update-a-user-by-id)", version: "0.0.2", annotations: { destructiveHint: true, openWorldHint: true, readOnlyHint: false, }, type: "action", props: { lucca, userId: { propDefinition: [ lucca, "userId", ], }, firstName: { type: "string", label: "First Name", description: "The user's first name", optional: true, }, lastName: { type: "string", label: "Last Name", description: "The user's last name", optional: true, }, mail: { type: "string", label: "Email", description: "The user's email", optional: true, }, login: { type: "string", label: "Login", description: "The user's login", optional: true, }, legalEntityId: { propDefinition: [ lucca, "legalEntityId", ], optional: true, }, calendarId: { type: "integer", label: "Calendar ID", description: "The ID of the calendar", optional: true, }, employeeNumber: { type: "string", label: "Employee Number", description: "The employee number", optional: true, }, birthDate: { type: "string", label: "Birth Date", description: "The birth date of the user. Format: 'YYYY-MM-DD'.", optional: true, }, address: { type: "string", label: "Address", description: "The address of the user", optional: true, }, bankName: { type: "string", label: "Bank Name", description: "The name of the bank", optional: true, }, directLine: { type: "string", label: "Direct Line", description: "The direct line of the user", optional: true, }, gender: { type: "string", label: "Gender", description: "The gender of the user", optional: true, }, nationality: { propDefinition: [ lucca, "nationalityId", ], optional: true, }, personalEmail: { type: "string", label: "Personal Email", description: "The personal email of the user", optional: true, }, personalMobile: { type: "string", label: "Personal Mobile", description: "The personal mobile of the user", optional: true, }, professionalMobile: { type: "string", label: "Professional Mobile", description: "The professional mobile of the user", optional: true, }, quote: { type: "string", label: "Quote", description: "The quote of the user", optional: true, }, }, async run({ $ }) { try { const { lucca, userId, ...data } = this; const response = await lucca.updateUserProfile({ $, userId, data, }); $.export("$summary", `Successfully updated user with ID: ${this.userId}`); return response; } catch ({ message }) { console.log("message: ", message); const parsedError = JSON.parse(message); throw new ConfigurationError(parsedError.Message || parsedError[0].message); } }, }; 

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
LuccaluccaappThis component uses the Lucca app.
User IDuserIdstringSelect a value from the drop down menu.
First NamefirstNamestring

The user's first name

Last NamelastNamestring

The user's last name

Emailmailstring

The user's email

Loginloginstring

The user's login

Legal Entity IDlegalEntityIdintegerSelect a value from the drop down menu.
Calendar IDcalendarIdinteger

The ID of the calendar

Employee NumberemployeeNumberstring

The employee number

Birth DatebirthDatestring

The birth date of the user. Format: 'YYYY-MM-DD'.

Addressaddressstring

The address of the user

Bank NamebankNamestring

The name of the bank

Direct LinedirectLinestring

The direct line of the user

Gendergenderstring

The gender of the user

NationalitynationalitystringSelect a value from the drop down menu.
Personal EmailpersonalEmailstring

The personal email of the user

Personal MobilepersonalMobilestring

The personal mobile of the user

Professional MobileprofessionalMobilestring

The professional mobile of the user

Quotequotestring

The quote of the user

Action Authentication

Lucca uses API keys for authentication. When you connect your Lucca account, Pipedream securely stores the keys so you can easily authenticate to Lucca APIs in both code and no-code steps.

About Lucca

12 HR and administrative software programs

More Ways to Connect Lucca + Airtable

Update User Info with Lucca API on New Field Created (Instant) from Airtable API
Airtable + Lucca
 
Try it
Update User Info with Lucca API on New Record Created, Updated or Deleted (Instant) from Airtable API
Airtable + Lucca
 
Try it
Update User Info with Lucca API on New, Modified or Deleted Records from Airtable API
Airtable + Lucca
 
Try it
Update User Info with Lucca API on New or Modified Field (Instant) from Airtable API
Airtable + Lucca
 
Try it
Update User Info with Lucca API on New or Modified Records in View from Airtable API
Airtable + Lucca
 
Try it
Update User Info with Lucca API on New Records in View from Airtable API
Airtable + Lucca
 
Try it
Update User Info with Lucca API on New Record(s) Created (Instant) from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New Field Created (Instant) from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New Record Created, Updated or Deleted (Instant) from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New, Modified or Deleted Records from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New or Modified Field (Instant) from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New or Modified Records in View from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New or Modified Records (Instant) from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New Records in View from Airtable API
Airtable + Lucca
 
Try it
Approve Or Deny Leave Request with Lucca API on New Record(s) Created (Instant) from Airtable API
Airtable + Lucca
 
Try it
Create Comment with Airtable API on New Expense Report Created from Lucca API
Lucca + Airtable
 
Try it
Create Field with Airtable API on New Expense Report Created from Lucca API
Lucca + Airtable
 
Try it
Create Multiple Records with Airtable API on New Expense Report Created from Lucca API
Lucca + Airtable
 
Try it
Create or Update Record with Airtable API on New Expense Report Created from Lucca API
Lucca + Airtable
 
Try it
Create Single Record with Airtable API on New Expense Report Created from Lucca API
Lucca + Airtable
 
Try it
New Field Created (Instant) from the Airtable API

Emit new event when a field is created in the selected table. See the documentation

 
Try it
New or Modified Field (Instant) from the Airtable API

Emit new event when a field is created or updated in the selected table

 
Try it
New or Modified Records (Instant) from the Airtable API

Emit new event for each new or modified record in a table or view

 
Try it
New or Modified Records in View from the Airtable API

Emit new event for each new or modified record in a view

 
Try it
New Record Created, Updated or Deleted (Instant) from the Airtable API

Emit new event when a record is added, updated, or deleted in a table or selected view.

 
Try it
New Record(s) Created (Instant) from the Airtable API

Emit new event for each new record in a table

 
Try it
New Records in View from the Airtable API

Emit new event for each new record in a view

 
Try it
New, Modified or Deleted Records from the Airtable API

Emit new event each time a record is added, updated, or deleted in an Airtable table. Supports tables up to 10,000 records

 
Try it
New Expense Report Created from the Lucca API

Emit new event when a new expense report is created by an employee. Useful for automating approval or finance workflows. See the documentation

 
Try it
New Leave Request from the Lucca API

Emit new event when a new leave request is submitted by an employee. See the documentation

 
Try it
New User Created from the Lucca API

Emit new event when a new user (employee) is created in Lucca. See the documentation

 
Try it
Create Comment with the Airtable API

Create a comment on a selected record. See the documentation

 
Try it
Create Field with the Airtable API

Create a new field in a table. See the documentation

 
Try it
Create Multiple Records with the Airtable API

Create one or more records in a table in a single operation with an array. See the documentation

 
Try it
Create or Update Record with the Airtable API

Create a new record or update an existing one. See the documentation

 
Try it
Create Single Record with the Airtable API

Adds a record to a table.

 
Try it
Create Table with the Airtable API

Create a new table. See the documentation

 
Try it
Delete Record with the Airtable API

Delete a selected record from a table. See the documentation

 
Try it
Get Record with the Airtable API

Get data of a selected record from a table. See the documentation

 
Try it
Get Record Or Create with the Airtable API

Get a specific record, or create one if it doesn't exist. See the documentation

 
Try it
List Bases with the Airtable API

Get the list of bases that can be accessed. See the documentation

 
Try it
List Records with the Airtable API

Retrieve records from a table, optionally sorting and filtering results. See the documentation

 
Try it
List Records in View with the Airtable API

Retrieve records from a view, optionally sorting and filtering results. See the documentation

 
Try it
List Tables with the Airtable API

Get a list of tables in the selected base. See the documentation

 
Try it
Search Records with the Airtable API

Search for a record by formula or by field value. See the documentation

 
Try it
Update Comment with the Airtable API

Update an existing comment on a selected record. See the documentation

 
Try it
Update Field with the Airtable API

Update an existing field in a table. See the documentation

 
Try it
Update Record with the Airtable API

Update a single record in a table by Record ID. See the documentation

 
Try it
Update Table with the Airtable API

Update an existing table. See the documentation

 
Try it
Approve Or Deny Leave Request with the Lucca API

Approve or Deny a pending leave request. See the documentation

 
Try it
Update User Info with the Lucca API

Update profile or HR information for an existing user. See the documentation

 
Try it

Explore Other Apps

1
-
24
of
2,900+
apps by most popular

Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Premium
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Premium
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Premium
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Premium
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
Premium
ServiceNow
ServiceNow
The smarter way to workflow
Slack
Slack
Slack is the AI-powered platform for work bringing all of your conversations, apps, and customers together in one place. Around the world, Slack is helping businesses of all sizes grow and send productivity through the roof.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.