Airtable Integration

1# Zapier Workflow: Airtable → XRechnung generieren
2 
3# 1. Trigger: Airtable – New Record (oder Updated Record)
4#    Base: "Aufträge"  |  Table: "Rechnungen"
5 
6# 2. Action: Webhooks by Zapier – Custom Request
7#    Method:  POST
8#    URL:     https://service.invoice-api.xhub.io/api/v1/invoice/de/xrechnung/generate
9#    Headers: Authorization: Bearer {{your_api_key}}
10#             Content-Type: application/json
11#    Body:
12{
13  "invoice": {
14    "invoiceNumber": "{{airtable_invoice_number}}",
15    "type": "invoice",
16    "issueDate":  "{{airtable_issue_date}}",
17    "dueDate":    "{{airtable_due_date}}",
18    "currency":   "EUR",
19    "seller": {
20      "name":        "{{airtable_seller_name}}",
21      "vatId":       "{{airtable_seller_vat_id}}",
22      "street":      "{{airtable_seller_street}}",
23      "city":        "{{airtable_seller_city}}",
24      "postalCode":  "{{airtable_seller_zip}}",
25      "countryCode": "DE"
26    },
27    "buyer": {
28      "name":        "{{airtable_buyer_name}}",
29      "vatId":       "{{airtable_buyer_vat_id}}",
30      "street":      "{{airtable_buyer_street}}",
31      "city":        "{{airtable_buyer_city}}",
32      "postalCode":  "{{airtable_buyer_zip}}",
33      "countryCode": "DE"
34    },
35    "countrySpecific": { "buyerReference": "{{airtable_buyer_ref}}" },
36    "items": [{
37      "position":    1,
38      "description": "{{airtable_item_desc}}",
39      "quantity":    {{airtable_quantity}},
40      "unit":        "C62",
41      "unitPrice":   {{airtable_unit_price}},
42      "taxRate":     19,
43      "netAmount":   {{airtable_net}},
44      "taxAmount":   {{airtable_tax}},
45      "grossAmount": {{airtable_gross}}
46    }],
47    "subtotal": {{airtable_subtotal}},
48    "total":    {{airtable_total}},
49    "taxSummary": [{ "taxRate": 19, "netAmount": {{airtable_subtotal}}, "taxAmount": {{airtable_tax_sum}} }],
50    "paymentTerms": { "dueDays": 30 }
51  }
52}
53 
54# 3. Action: Airtable – Update Record
55#    Field "XRechnung_URL": {{zapier_step2_filename}}
56#    Field "Status":        "Rechnung erstellt"

1// Make.com Szenario: Airtable → ZUGFeRD generieren
2 
3// Modul 1: Airtable – Watch Records
4//   Base:   "Aufträge"
5//   Table:  "Rechnungen"
6//   Filter: {Status} = "Abgeschlossen"
7 
8// Modul 2: HTTP – Make a request
9{
10  "url": "https://service.invoice-api.xhub.io/api/v1/invoice/de/zugferd/generate",
11  "method": "POST",
12  "headers": [
13    { "name": "Authorization", "value": "Bearer {{connection.apiKey}}" },
14    { "name": "Content-Type",  "value": "application/json" }
15  ],
16  "body": {
17    "invoice": {
18      "invoiceNumber": "{{1.invoiceNumber}}",
19      "type":          "invoice",
20      "issueDate":     "{{1.issueDate}}",
21      "seller": {
22        "name":        "{{1.sellerName}}",
23        "vatId":       "{{1.sellerVatId}}",
24        "street":      "{{1.sellerStreet}}",
25        "city":        "{{1.sellerCity}}",
26        "postalCode":  "{{1.sellerZip}}",
27        "countryCode": "DE"
28      },
29      "buyer": {
30        "name":        "{{1.buyerName}}",
31        "vatId":       "{{1.buyerVatId}}",
32        "street":      "{{1.buyerStreet}}",
33        "city":        "{{1.buyerCity}}",
34        "postalCode":  "{{1.buyerZip}}",
35        "countryCode": "DE"
36      },
37      "items": [{ "position": 1, "description": "{{1.itemDesc}}",
38        "quantity": "{{1.qty}}", "unit": "C62", "unitPrice": "{{1.price}}",
39        "taxRate": 19, "netAmount": "{{1.net}}", "taxAmount": "{{1.tax}}",
40        "grossAmount": "{{1.gross}}" }],
41      "subtotal": "{{1.subtotal}}",
42      "total":    "{{1.total}}",
43      "taxSummary": [{ "taxRate": 19, "netAmount": "{{1.subtotal}}", "taxAmount": "{{1.taxSum}}" }],
44      "paymentTerms": { "dueDays": 30 }
45    }
46  }
47}
48 
49// Modul 3: Airtable – Update a Record
50//   Record-ID: {{1.id}}
51//   ZUGFeRD_PDF: {{2.filename}}
52//   Status:      "Rechnung erstellt"