Untitled

The Webhook Trigger is working. Here is the output with little changes. ;)

{
  "body": [
    {
      "id": "srfc42fb2b5b6d4517bff656af7232632",
      "csv": {
        "url": "<https://api.formcan.com/v4/download/submission/csv/srfc42fb2b5b6d4517bff656af7232632>",
        "file_name": "Enquête Flatcard.csv",
        "sharing_creator_url": "<https://api.formcan.com/v4/sharing/submission/csv/srfc42fb2b5b6d4517bff656af7232632>"
      },
      "pdf": {
        "url": "<https://api.formcan.com/v4/download/submission/pdf/srfc42fb2b5b6d4517bff656af7232632>",
        "file_name": "Enquête Flatcard.pdf",
        "sharing_creator_url": "<https://api.formcan.com/v4/sharing/submission/pdf/srfc42fb2b5b6d4517bff656af7232632>"
      },
      "form": {
        "id": "frilq50jz86",
        "name": "Enquête Flatcard"
      },
      "add_ons": [],
      "submitter": {
        "email": "@gmail.com",
        "full_name": "Alexandre"
      },
      "ip_address": "89.0.0.9",
      "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36",
      "attachments": [],
      "submit_data": [
        {
          "id": "fid4",
          "raw": null,
          "type": "number",
          "label": "Quel âge avez-vous ?",
          "value": "89"
        },
        {
          "id": "fid6",
          "raw": null,
          "type": "number",
          "label": "Quel est le code postal de votre ville de résidence?",
          "value": "7000"
        },
        {
          "id": "fid7",
          "raw": [
            {
              "id": "2",
              "url": null,
              "value": "Non"
            }
          ],
          "type": "Choice",
          "label": "Êtes-vous propriétaire d'un bien que vous mettez en location ?",
          "value": "Non"
        },
        {
          "id": "fid30",
          "raw": [
            {
              "id": "2",
              "url": null,
              "value": "Non"
            }
          ],
          "type": "Choice",
          "label": "Êtes-vous locataire ou avez-vous été locataire d'un bien.",
          "value": "Non"
        }
      ],
      "submit_date": "2023-12-04T22:06:38Z",
      "workflow_id": null,
      "attachments_zip": {},
      "submit_form_url": "<https://form.formcan.com/frilq50jz86/?sid=srfc42fb2b5b6d4517bff656af7232632&pver=7>",
      "submit_revision": 1,
      "sign_certificate": {},
      "workflow_step_id": null,
      "workflow_next_step_url": null,
      "published_form_revision": 7,
      "workflow_next_step_api_url": null,
      "submit_form_sharing_creator_url": "<https://api.formcan.com/v4/sharing/submission/editor/srfc42fb2b5b6d4517bff656af7232632>"
    }
  ],
  "method": "POST",
  "headers": {
    "host": "cloud.activepieces.com",
    "accept": "*/*",
    "cf-ray": "83075ba0aed5061e-IAD",
    "cdn-loop": "cloudflare",
    "x-real-ip": "",
    "cf-visitor": "{\\"scheme\\":\\"https\\"}",
    "connection": "close",
    "user-agent": "python-requests/2.31.0",
    "cf-ipcountry": "US",
    "content-type": "application/json",
    "content-length": "2021",
    "accept-encoding": "gzip",
    "x-forwarded-for": "",
    "cf-connecting-ip": "",
    "x-forwarded-host": "cloud.activepieces.com",
    "x-forwarded-port": "443",
    "x-forwarded-proto": "https",
    "x-forwarded-server": "f196bceeac2c"
  },
  "queryParams": {}
}```

Then on Airtable

Untitled

I authorized write and read

Untitled

I choose dynamic value for each data

Untitled