Loading

Airtable + Fatture in Cloud

Create new Airtable records from new raw events in Fatture in Cloud

When a new event is received in Fatture in Cloud, this streamlined automation swiftly records the details in your Airtable. Save time and keep your data organized without lifting a finger. Perfect for those looking to optimize their workflow and maintain accurate record-keeping with ease.

When a new event is received in Fatture in Cloud, this streamlined automation swiftly records the details in your Airtable. Save time and keep your data organized without lifting a finger. Perfect for those looking to optimize their workflow and maintain accurate record-keeping with ease.

  1. When this happens...
    Fatture in CloudFatture in Cloud
    Receive Raw Event

    Triggers when a webhooks arrives from Fatture in Cloud, returns an array of ids.

    TriggerInstant
  2. automatically do this!
    AirtableAirtable
    Create Record

    Creates a new record with auto-populating fields.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Company IDRequired

    • Resource TypeRequired

    • Event TypesRequired

    Trigger
    Instant
    Try It
    • The ID of the company.Required

    • Archive document id - [data.id]

    • Archive document date - [data.date]

    • Archive Document description - [data.description]

    • [Temporary] [Read Only] Archive Document url of the attached file - [data.attachment_url]

    • Archive document category - [data.category]

    • [Write Only] [Required] Archive document attachment token returned by POST /archive/attachment - [data.attachment_token]

    Action
    Write
    • The ID of the company.Required

    • Client id - [data.id]

    • Client code - [data.code]

    • Client name - [data.name]

    • Client type - [data.type]

    • Client first name - [data.first_name]

    • Client last name - [data.last_name]

    • Client contact person - [data.contact_person]

    • Client vat number - [data.vat_number]

    • Client tax code - [data.tax_code]

    • Client address street - [data.address_street]

    • Client address postal code - [data.address_postal_code]

    • Client address city - [data.address_city]

    • Client address province - [data.address_province]

    • Client address extra info - [data.address_extra]

    • Client country - [data.country]

    • Client country iso code - [data.country_iso]

    • Client email - [data.email]

    • Client certified email - [data.certified_email]

    • Client phone - [data.phone]

    • Client fax - [data.fax]

    • Client extra - [data.notes]

    • Vat type id - [data.default_vat.id]

    • [Read Only] Vat type percentual value - [data.default_vat.value]

    • Vat type short description - [data.default_vat.description]

    • Vat type notes shown in documents - [data.default_vat.notes]

    • Vat type is usable for e-invoices - [data.default_vat.e_invoice]

    • Vat type e-invoice type (natura) - [data.default_vat.ei_type]

    • Vat type e-invoice description - [data.default_vat.ei_description]

    • [Read Only] Is the vat type is editable. - [data.default_vat.editable]

    • Is the vat type disabled - [data.default_vat.is_disabled]

    • Client default payment terms - [data.default_payment_terms]

    • Payment terms type - [data.default_payment_terms_type]

    • Payment method id - [data.default_payment_method.id]

    • Payment method name - [data.default_payment_method.name]

    • Payment method type - [data.default_payment_method.type]

    • Payment method is default - [data.default_payment_method.is_default]

    • Payment account id - [data.default_payment_method.default_payment_account.id]

    • Payment account name - [data.default_payment_method.default_payment_account.name]

    • Payment account type - [data.default_payment_method.default_payment_account.type]

    • Payment account iban - [data.default_payment_method.default_payment_account.iban]

    • Payment account sia - [data.default_payment_method.default_payment_account.sia]

    • Payment account cuc - [data.default_payment_method.default_payment_account.cuc]

    • Payment method is virtual - [data.default_payment_method.default_payment_account.virtual]

    • Payment method details title - [data.default_payment_method.details.title]

    • Payment method details description - [data.default_payment_method.details.description]

    • Payment method bank iban - [data.default_payment_method.bank_iban]

    • Payment method bank name - [data.default_payment_method.bank_name]

    • Payment method bank beneficiary - [data.default_payment_method.bank_beneficiary]

    • E-invoice payment method - [data.default_payment_method.ei_payment_method]

    • Client bank name - [data.bank_name]

    • Client bank iban - [data.bank_iban]

    • Client bank swift code - [data.bank_swift_code]

    • Client shipping address - [data.shipping_address]

    • Use e-invoices for this entity - [data.e_invoice]

    • Client e-invoice code - [data.ei_code]

    • Highlight Discount - [data.discount_highlight]

    • Client default discount - [data.default_discount]

    • Client has intent declaration - [data.has_intent_declaration]

    • Client intent declaration protocol number - [data.intent_declaration_protocol_number]

    • Client intent declaration protocol date - [data.intent_declaration_protocol_date]

    • Client creation date - [data.created_at]

    • Client last update date - [data.updated_at]

    Action
    Write
    • The ID of the company.Required

    • Issued document id - [data.id]

    • Entity id - [data.entity.id]

    • Entity code - [data.entity.code]

    • Entity name - [data.entity.name]

    • Entity type - [data.entity.type]

    • Entity first name - [data.entity.first_name]

    • Entity last name - [data.entity.last_name]

    • Entity contact person - [data.entity.contact_person]

    • Entity vat number - [data.entity.vat_number]

    • Entity tax code - [data.entity.tax_code]

    • Entitity address street - [data.entity.address_street]

    • Entity address postal code - [data.entity.address_postal_code]

    • Entity address city - [data.entity.address_city]

    • Entity address province - [data.entity.address_province]

    • Entity address extra info - [data.entity.address_extra]

    • Entity country - [data.entity.country]

    • Entity country iso code - [data.entity.country_iso]

    • Entity email - [data.entity.email]

    • Entity certified email - [data.entity.certified_email]

    • Entity phone - [data.entity.phone]

    • Entity fax - [data.entity.fax]

    • Entity extra - [data.entity.notes]

    • [Only for client] Client default payment terms - [data.entity.default_payment_terms]

    • Vat type id - [data.entity.default_vat.id]

    • [Read Only] Vat type percentual value - [data.entity.default_vat.value]

    • Vat type short description - [data.entity.default_vat.description]

    • Vat type notes shown in documents - [data.entity.default_vat.notes]

    • Vat type is usable for e-invoices - [data.entity.default_vat.e_invoice]

    • Vat type e-invoice type (natura) - [data.entity.default_vat.ei_type]

    • Vat type e-invoice description - [data.entity.default_vat.ei_description]

    • [Read Only] Is the vat type is editable. - [data.entity.default_vat.editable]

    • Is the vat type disabled - [data.entity.default_vat.is_disabled]

    • Payment terms type - [data.entity.default_payment_terms_type]

    • Payment method id - [data.entity.default_payment_method.id]

    • Payment method name - [data.entity.default_payment_method.name]

    • Payment method type - [data.entity.default_payment_method.type]

    • Payment method is default - [data.entity.default_payment_method.is_default]

    • Payment account id - [data.entity.default_payment_method.default_payment_account.id]

    • Payment account name - [data.entity.default_payment_method.default_payment_account.name]

    • Payment account type - [data.entity.default_payment_method.default_payment_account.type]

    • Payment account iban - [data.entity.default_payment_method.default_payment_account.iban]

    • Payment account sia - [data.entity.default_payment_method.default_payment_account.sia]

    • Payment account cuc - [data.entity.default_payment_method.default_payment_account.cuc]

    • Payment method is virtual - [data.entity.default_payment_method.default_payment_account.virtual]

    • Payment method details title - [data.entity.default_payment_method.details.title]

    • Payment method details description - [data.entity.default_payment_method.details.description]

    • Payment method bank iban - [data.entity.default_payment_method.bank_iban]

    • Payment method bank name - [data.entity.default_payment_method.bank_name]

    • Payment method bank beneficiary - [data.entity.default_payment_method.bank_beneficiary]

    • E-invoice payment method - [data.entity.default_payment_method.ei_payment_method]

    • [Only for client] Client bank name - [data.entity.bank_name]

    • [Only for client] Client bank iban - [data.entity.bank_iban]

    • [Only for client] Client bank swift code - [data.entity.bank_swift_code]

    • [Only for client] Client Shipping address - [data.entity.shipping_address]

    • [Only for client] Use e-invoices. - [data.entity.e_invoice]

    • [Only for client] E-invoices code. - [data.entity.ei_code]

    • [Only for client] Has intent declaration. - [data.entity.has_intent_declaration]

    • [Only for client] Client intent declaration protocol number - [data.entity.intent_declaration_protocol_number]

    • [Only for client] Client intent declaration protocol date - [data.entity.intent_declaration_protocol_date]

    • Entity creation date - [data.entity.created_at]

    • Entity last update date - [data.entity.updated_at]

    • Issued document type - [data.type]

    • Issued document number [If not specified, next number is used] - [data.number]

    • Issued document numeration [Not available if type=delivery_note] - [data.numeration]

    • Issued document date [defaults to today's date] - [data.date]

    • Issued document year - [data.year]

    • Currency code - [data.currency.id]

    • Currency symbol - [data.currency.symbol]

    • Currency exchange rate (EUR to this) - [data.currency.exchange_rate]

    • Currency html code - [data.currency.html_symbol]

    • Language code - [data.language.code]

    • Language extended name - [data.language.name]

    • Issued document subject - [data.subject]

    • Issued document visible subject - [data.visible_subject]

    • Issued document revenue center [or cost center if type=supplier_order]. - [data.rc_center]

    • Issued document extra notes - [data.notes]

    • Issued document "Rivalsa INPS" percentual value - [data.rivalsa]

    • Issued document "Cassa previdenziale" percentual value - [data.cassa]

    • [Read Only] Issued document cassa amount. - [data.amount_cassa]

    • Issued document cassa taxable percentage - [data.cassa_taxable]

    • [Can be set only if cassa_taxable is NULL] Issued document cassa taxable amount - [data.amount_cassa_taxable]

    • Issued document "Cassa previdenziale 2" percentual value - [data.cassa2]

    • [Read Only] Issued document cassa2 amount - [data.amount_cassa2]

    • Issued document cassa2 taxable percentage - [data.cassa2_taxable]

    • [Can be set only if cassa2_taxable is NULL] Issued document cassa2 taxable amount - [data.amount_cassa2_taxable]

    • Issued document global cassa taxable percentage - [data.global_cassa_taxable]

    • [Can be set only if global_cassa_taxable is NULL] Issued document global cassa taxable amount - [data.amount_global_cassa_taxable]

    • Issued document withholding tax (ritenuta d'acconto) percentual value - [data.withholding_tax]

    • Issued document withholding tax taxable (imponibile) percentual value - [data.withholding_tax_taxable]

    • Issued document other withholding tax (altra ritenuta) percentual value - [data.other_withholding_tax]

    • Issued document stamp duty value [0 if not present] - [data.stamp_duty]

    • Payment method id - [data.payment_method.id]

    • Payment method name - [data.payment_method.name]

    • Payment method type - [data.payment_method.type]

    • Payment method is default - [data.payment_method.is_default]

    • Payment account id - [data.payment_method.default_payment_account.id]

    • Payment account name - [data.payment_method.default_payment_account.name]

    • Payment account type - [data.payment_method.default_payment_account.type]

    • Payment account iban - [data.payment_method.default_payment_account.iban]

    • Payment account sia - [data.payment_method.default_payment_account.sia]

    • Payment account cuc - [data.payment_method.default_payment_account.cuc]

    • Payment method is virtual - [data.payment_method.default_payment_account.virtual]

    • Payment method details title - [data.payment_method.details.title]

    • Payment method details description - [data.payment_method.details.description]

    • Payment method bank iban - [data.payment_method.bank_iban]

    • Payment method bank name - [data.payment_method.bank_name]

    • Payment method bank beneficiary - [data.payment_method.bank_beneficiary]

    • E-invoice payment method - [data.payment_method.ei_payment_method]

    • Issued document uses split payment - [data.use_split_payment]

    • Issued document uses gross prices - [data.use_gross_prices]

    • Issued document is an e-invoice. - [data.e_invoice]

    • Vat kind [esigibilità IVA] - [data.ei_data.vat_kind]

    • Issued document original document type - [data.ei_data.original_document_type]

    • E-invoice original document number - [data.ei_data.od_number]

    • E-invoice original document date - [data.ei_data.od_date]

    • E-invoice CIG - [data.ei_data.cig]

    • E-invoice CUP - [data.ei_data.cup]

    • E-invoice payment method [required for e-invoices] (see [here](https://www.fatturapa.gov.it/export/documenti/fatturapa/v1.2.2/Rappresentazione_Tabellare_FattOrdinaria_V1.2.2.pdf) for the accepted values of ModalitaPagamento) - [data.ei_data.payment_method]

    • E-invoice bank name - [data.ei_data.bank_name]

    • E-invoice bank IBAN - [data.ei_data.bank_iban]

    • E-invoice bank beneficiary - [data.ei_data.bank_beneficiary]

    • E-invoice invoice number - [data.ei_data.invoice_number]

    • E-invoice invoice date - [data.ei_data.invoice_date]

    • E-invoice cassa type - [data.ei_cassa_type]

    • E-invoice cassa2 type - [data.ei_cassa2_type]

    • E-invoice withholding tax causal - [data.ei_withholding_tax_causal]

    • E-invoice other withholding tax type - [data.ei_other_withholding_tax_type]

    • E-invoice other withholding tax causal - [data.ei_other_withholding_tax_causal]

    • Issued document item id - [data.items_list.id]

    • Issued document item product id - [data.items_list.product_id]

    • Issued document item product code - [data.items_list.code]

    • Issued document item product name - [data.items_list.name]

    • Issued document item product category - [data.items_list.category]

    • Issued document product description - [data.items_list.description]

    • Issued document item quantity - [data.items_list.qty]

    • Issued document item measure - [data.items_list.measure]

    • Issued document item net price - [data.items_list.net_price]

    • Issued document item gross price - [data.items_list.gross_price]

    • Vat type id - [data.items_list.vat.id]

    • [Read Only] Vat type percentual value - [data.items_list.vat.value]

    • Vat type short description - [data.items_list.vat.description]

    • Vat type notes shown in documents - [data.items_list.vat.notes]

    • Vat type is usable for e-invoices - [data.items_list.vat.e_invoice]

    • Vat type e-invoice type (natura) - [data.items_list.vat.ei_type]

    • Vat type e-invoice description - [data.items_list.vat.ei_description]

    • [Read Only] Is the vat type is editable. - [data.items_list.vat.editable]

    • Is the vat type disabled - [data.items_list.vat.is_disabled]

    • Issued document item is not taxable - [data.items_list.not_taxable]

    • Issued document item apply withholding taxes, rivalsa and cassa - [data.items_list.apply_withholding_taxes]

    • Issued document item discount percentual value - [data.items_list.discount]

    • Issued document item highlight discount - [data.items_list.discount_highlight]

    • Issued document item add in delivery note - [data.items_list.in_dn]

    • Issued document item move stock - [data.items_list.stock]

    • Issued document advanced raw attributes for e-invoices - [data.items_list.ei_raw]

    • Issued document payment item id - [data.payments_list.id]

    • Issued document payment due date - [data.payments_list.due_date]

    • Issued document payment amount - [data.payments_list.amount]

    • Issued document status - [data.payments_list.status]

    • Payment account id - [data.payments_list.payment_account.id]

    • Payment account name - [data.payments_list.payment_account.name]

    • Payment account type - [data.payments_list.payment_account.type]

    • Payment account iban - [data.payments_list.payment_account.iban]

    • Payment account sia - [data.payments_list.payment_account.sia]

    • Payment account cuc - [data.payments_list.payment_account.cuc]

    • Payment method is virtual - [data.payments_list.payment_account.virtual]

    • Issued document payment date [Only if status is paid] - [data.payments_list.paid_date]

    • Issued document payment advanced raw attributes for e-invoices - [data.payments_list.ei_raw]

    • Issued document payment number of days by which the payment must be made - [data.payments_list.payment_terms.days]

    • Payment terms type - [data.payments_list.payment_terms.type]

    • Template id - [data.template.id]

    • Template name - [data.template.name]

    • Template type - [data.template.type]

    • Template id - [data.delivery_note_template.id]

    • Template name - [data.delivery_note_template.name]

    • Template type - [data.delivery_note_template.type]

    • Template id - [data.acc_inv_template.id]

    • Template name - [data.acc_inv_template.name]

    • Template type - [data.acc_inv_template.type]

    • Issued document PDF horizontal margins - [data.h_margins]

    • Issued document PDF vertical margins - [data.v_margins]

    • Show the expiration dates of the payments on the document - [data.show_payments]

    • Show the payment method details on the document - [data.show_payment_method]

    • Show totals mode - [data.show_totals]

    • Show notification button in the PDF - [data.show_notification_button]

    • Show ts pay button in the PDF - [data.show_tspay_button]

    • Issued document has delivery note - [data.delivery_note]

    • Issued document has an accompanying invoice - [data.accompanying_invoice]

    • Issued document attached delivery note number - [data.dn_number]

    • Issued document attached delivery note date - [data.dn_date]

    • Issued document attached delivery note number of packages - [data.dn_ai_packages_number]

    • Issued document attached delivery note package weight - [data.dn_ai_weight]

    • Issued document attached delivery note causal - [data.dn_ai_causal]

    • Issued document attached delivery note destination - [data.dn_ai_destination]

    • Issued document attached delivery note transporter - [data.dn_ai_transporter]

    • Issued document attached delivery note notes - [data.dn_ai_notes]

    • Issued document is marked - [data.is_marked]

    • [Read only] Issued document total net amount - [data.amount_net]

    • [Read Only] Issued document total vat amount - [data.amount_vat]

    • [Read Only] Issued document total gross amount - [data.amount_gross]

    • Issued document amount due discount - [data.amount_due_discount]

    • [Read Only] Issued document rivalsa amount - [data.amount_rivalsa]

    • Issued document taxable rivalsa amount - [data.amount_rivalsa_taxable]

    • [Read Only] Issued document withholding tax amount (ritenuta d'acconto). - [data.amount_withholding_tax]

    • Issued document taxable withholding tax amount - [data.amount_withholding_tax_taxable]

    • [Read Only] Issued document other withholding tax amount (altra ritenuta) - [data.amount_other_withholding_tax]

    • Issued document taxable other withholding tax amount - [data.amount_other_withholding_tax_taxable]

    • Issued document taxable enasarco amount - [data.amount_enasarco_taxable]

    • [data.extra_data.multifatture_sent]

    • Send issued document to "Sistema Tessera Sanitaria" - [data.extra_data.ts_communication]

    • Issued document ts "tipo spesa" [TK, FC, FV, SV,SP, AD, AS, ECG, SR] - [data.extra_data.ts_flag_tipo_spesa]

    • Issued document ts traced payment - [data.extra_data.ts_pagamento_tracciato]

    • Can be [ 'TK', 'FC', 'FV', 'SV', 'SP', 'AD', 'AS', 'SR', 'CT', 'PI', 'IC', 'AA' ]. Refer to the technical specifications to learn more. - [data.extra_data.ts_tipo_spesa]

    • Issued document ts "opposizione" - [data.extra_data.ts_opposizione]

    • Issued document ts status - [data.extra_data.ts_status]

    • Issued document ts file id - [data.extra_data.ts_file_id]

    • Issued document ts sent date - [data.extra_data.ts_sent_date]

    • Issued document ts total amount - [data.extra_data.ts_full_amount]

    • Issued document imported by software - [data.extra_data.imported_by]

    • Issued document seen date - [data.seen_date]

    • Issued document date of the next not paid payment - [data.next_due_date]

    • [Temporary] [Read Only] Issued document url of the document PDF file - [data.url]

    • [Temporary] [Read Only] Issued document url of the attached delivery note PDF file - [data.dn_url]

    • [Temporary] [Read Only] Issued document url of the accompanying invoice PDF file - [data.ai_url]

    • [Temporary] [Read Only] Issued document url of the attached file - [data.attachment_url]

    • [Write Only] Issued document attachment token returned by POST /issued_documents/attachment - [data.attachment_token]

    • Issued document advanced raw attributes for e-invoices - [data.ei_raw]

    • [Read only] Status of the e-invoice. * **attempt** - We are trying to send the invoice, please wait up to 2 hours * **missing** - The invoice is missing * **not_sent** - The invoice has yet to be sent * **sent** - The invoice was sent * **pending** - The checks for the digital signature and sending are in progress * **processing** - The SDI is delivering the invoice to the customer * **error** - An error occurred while handling the invoice, please try to resend it or contact support * **discarded** - The invoice has been rejected by the SDI, so it must be corrected and re-sent * **not_delivered** - The SDI was unable to deliver the invoice * **accepted** - The customer accepted the invoice * **rejected** - The customer rejected the invoice, so it must be corrected * **no_response** - A response has not yet been received whithin the deadline, contact the customer to ascertain the status of the invoice * **manual_accepted** - The customer accepted the invoice * **manual_rejected** - The customer rejected the invoice - [data.ei_status]

    • Issued Document can't be edited - [data.locked]

    • Issued document creation date - [data.created_at]

    • Issued document last update date - [data.updated_at]

    • Fixes your last payment amount to match your document total - [options.fix_payments]

    • Original documents ids [only for join/transform] - [options.create_from]

    • Tranform a document [only for transform] - [options.transform]

    • Keep original document [only for transform] - [options.keep_copy]

    • Join type [only for join] - [options.join_type]

    Action
    Write
    • Company IDRequired

    • Resource TypeRequired

    • Event TypesRequired

    Trigger
    Instant
    Try It
    • The ID of the company.Required

    • Cashbook id - [data.id]

    • Cashbook date - [data.date]

    • Cashbook description - [data.description]

    • Cashbook kind - [data.kind]

    • Cashbook type - [data.type]

    • Cashbook entity name - [data.entity_name]

    • Cashbook related document id - [data.document.id]

    • Cashbook related document type - [data.document.type]

    • Cashbook related document path - [data.document.path]

    • [Only for cashbook entry in] Cashbook total amount in - [data.amount_in]

    • Payment account id - [data.payment_account_in.id]

    • Payment account name - [data.payment_account_in.name]

    • Payment account type - [data.payment_account_in.type]

    • Payment account iban - [data.payment_account_in.iban]

    • Payment account sia - [data.payment_account_in.sia]

    • Payment account cuc - [data.payment_account_in.cuc]

    • Payment method is virtual - [data.payment_account_in.virtual]

    • [Only for cashbook entry out] Cashbook total amount out - [data.amount_out]

    • Payment account id - [data.payment_account_out.id]

    • Payment account name - [data.payment_account_out.name]

    • Payment account type - [data.payment_account_out.type]

    • Payment account iban - [data.payment_account_out.iban]

    • Payment account sia - [data.payment_account_out.sia]

    • Payment account cuc - [data.payment_account_out.cuc]

    • Payment method is virtual - [data.payment_account_out.virtual]

    Action
    Write
    • The ID of the company.Required

    • F24 id - [data.id]

    • F24 due date - [data.due_date]

    • F24 status - [data.status]

    • Payment account id - [data.payment_account.id]

    • Payment account name - [data.payment_account.name]

    • Payment account type - [data.payment_account.type]

    • Payment account iban - [data.payment_account.iban]

    • Payment account sia - [data.payment_account.sia]

    • Payment account cuc - [data.payment_account.cuc]

    • Payment method is virtual - [data.payment_account.virtual]

    • F24 amount - [data.amount]

    • [Temporary] [Read Only] F24 url of the attached file - [data.attachment_url]

    • [Write Only] F24 attachment token returned by POST /taxes/attachment - [data.attachment_token]

    • F24 description - [data.description]

    Action
    Write
    • The ID of the company.Required

    • Payment account id - [data.id]

    • Payment account name - [data.name]

    • Payment account type - [data.type]

    • Payment account iban - [data.iban]

    • Payment account sia - [data.sia]

    • Payment account cuc - [data.cuc]

    • Payment method is virtual - [data.virtual]

    Action
    Write
airtable logo

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.
Learn moreHelp

Related categories

  • Databases

Similar apps

Quickbase integrationsQuickbase integrations

Quickbase

Databases
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
fatture-in-cloud logo

About Fatture in Cloud

Fatture in Cloud is an italian online invoicing software with all the tools you need keep your business under control.

Related categories