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.
- When this happens...Receive Raw Event
Triggers when a webhooks arrives from Fatture in Cloud, returns an array of ids.
- automatically do this!Create Record
Creates a new record with auto-populating fields.
- Free forever for core features
- 14 day trial for premium features & apps
Company IDRequired
Resource TypeRequired
Event TypesRequired
Try ItThe 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]
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]
If the vat type is default - [data.default_vat.default]
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]
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]
If the vat type is default - [data.entity.default_vat.default]
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 [not shown on the PDF] - [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]
If the vat type is default - [data.items_list.vat.default]
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]
Company IDRequired
Resource TypeRequired
Event TypesRequired
Try ItThe 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]
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]
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]
