Recevez une alerte instantanée dès qu’un budget projet ou département dépasse un seuil critique, pour réagir rapidement.
Recevez une alerte instantanée dès qu’un budget projet ou département dépasse un seuil critique, pour réagir rapidement.
{
"name": "Automate your invoice data extraction with Rossum Elis and store the results in Google Sheets",
"flow": [
{
"id": 8,
"module": "http:ActionSendDataBasicAuth",
"version": 3,
"parameters": {
"handleErrors": false
},
"mapper": {
"ca": "",
"qs": [],
"url": "https://api.elis.rossum.ai/v1/annotations",
"gzip": true,
"method": "get",
"headers": [],
"timeout": "",
"bodyType": "",
"shareCookies": false,
"parseResponse": true,
"followRedirect": true,
"useQuerystring": false,
"rejectUnauthorized": true
},
"metadata": {
"designer": {
"x": -54,
"y": -52
},
"restore": {
"qs": {
"mode": "chose",
"items": []
},
"method": {
"mode": "chose",
"label": "GET"
},
"headers": {
"mode": "chose",
"items": []
},
"bodyType": {
"label": ""
}
},
"parameters": [
{
"name": "key",
"type": "keychain",
"label": "Credentials",
"required": true
},
{
"name": "handleErrors",
"type": "boolean",
"label": "Evaluate all states as errors (except for 2xx and 3xx )",
"required": true
}
],
"expect": [
{
"name": "url",
"type": "url",
"label": "URL",
"required": true
},
{
"name": "method",
"type": "select",
"label": "Method",
"required": true,
"validate": {
"enum": [
"get",
"head",
"post",
"put",
"patch",
"delete"
]
}
},
{
"name": "headers",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Headers",
"labels": {
"add": "Add a header",
"edit": "Edit a header"
}
},
{
"name": "qs",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Query String",
"labels": {
"add": "Add parameter",
"edit": "Edit parameter"
}
},
{
"name": "bodyType",
"type": "select",
"label": "Body type",
"validate": {
"enum": [
"raw",
"x_www_form_urlencoded",
"multipart_form_data"
]
}
},
{
"name": "parseResponse",
"type": "boolean",
"label": "Parse response",
"required": true
},
{
"name": "timeout",
"type": "uinteger",
"label": "Timeout",
"validate": {
"max": 300,
"min": 1
}
},
{
"name": "shareCookies",
"type": "boolean",
"label": "Share cookies with other HTTP modules",
"required": true
},
{
"name": "ca",
"type": "cert",
"label": "Self-signed certificate",
"multiline": true
},
{
"name": "rejectUnauthorized",
"type": "boolean",
"label": "Reject connections that are using unverified (self-signed) certificates",
"required": true
},
{
"name": "followRedirect",
"type": "boolean",
"label": "Follow redirect",
"required": true
},
{
"name": "useQuerystring",
"type": "boolean",
"label": "Disable serialization of multiple same query string keys as arrays",
"required": true
},
{
"name": "gzip",
"type": "boolean",
"label": "Request compressed content",
"required": true
}
]
}
},
{
"id": 22,
"module": "builtin:BasicFeeder",
"version": 1,
"parameters": {},
"mapper": {
"array": "{{8.data.results}}"
},
"metadata": {
"designer": {
"x": 238,
"y": -44
},
"restore": {
"array": {
"mode": "edit"
}
},
"expect": [
{
"mode": "edit",
"name": "array",
"spec": [],
"type": "array",
"label": "Array"
}
]
}
},
{
"id": 4,
"module": "rossum-elis:exportAnnotation",
"version": 1,
"parameters": {},
"filter": {
"name": "If Invoice Ready",
"conditions": [
[
{
"a": "{{8.data.results[].status}}",
"b": "to_review",
"o": "text:equal"
}
],
[
{
"a": "{{8.data.results[].status}}",
"b": "exported",
"o": "text:equal"
}
]
]
},
"mapper": {
"annotation": "{{22.url}}"
},
"metadata": {
"designer": {
"x": 548,
"y": -48
},
"restore": {},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "workspace",
"type": "select",
"label": "Workspace",
"required": true
},
{
"name": "annotation",
"type": "text",
"label": "Annotation ID or URL",
"required": true
},
{
"name": "queue",
"type": "select",
"label": "Queue",
"required": true
}
]
}
},
{
"id": 21,
"module": "google-sheets:addRow",
"version": 2,
"parameters": {},
"mapper": {
"mode": "select",
"values": {
"0": "{{4.invoice_details_section.invoice_id}}",
"1": "{{4.vendor_section.sender_name}}",
"2": "{{4.totals_section.amount_total_base}}",
"3": "{{4.totals_section.amount_total_tax}}",
"4": "{{4.totals_section.amount_due}}",
"5": "{{4.totals_section.currency}}",
"6": "{{4.invoice_details_section.date_issue}}",
"7": "{{4.invoice_details_section.date_due}}"
},
"tableFirstRow": "A1:Z1",
"includesHeaders": false,
"insertDataOption": "INSERT_ROWS",
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 852,
"y": -46
},
"restore": {
"mode": {
"label": "Select spreadsheet and sheet"
},
"tableFirstRow": {
"label": "A-Z"
},
"includesHeaders": {
"label": "No"
},
"insertDataOption": {
"mode": "chose",
"label": "Insert rows"
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Mode",
"required": true,
"validate": {
"enum": [
"select",
"map"
]
}
},
{
"name": "valueInputOption",
"type": "select",
"label": "Value input option",
"validate": {
"enum": [
"USER_ENTERED",
"RAW"
]
}
},
{
"name": "insertDataOption",
"type": "select",
"label": "Insert data option",
"validate": {
"enum": [
"INSERT_ROWS",
"OVERWRITE"
]
}
},
{
"name": "spreadsheetId",
"type": "select",
"label": "Spreadsheet",
"required": true
},
{
"name": "sheetId",
"type": "select",
"label": "Sheet",
"required": true
},
{
"name": "includesHeaders",
"type": "select",
"label": "Table contains headers",
"required": true,
"validate": {
"enum": [
true,
false
]
}
},
{
"name": "tableFirstRow",
"type": "select",
"label": "Column range",
"required": true,
"validate": {
"enum": [
"A1:Z1",
"A1:BZ1",
"A1:CZ1",
"A1:DZ1",
"A1:MZ1",
"A1:ZZ1"
]
}
},
{
"name": "values",
"spec": [
{
"name": "__SPREADSHEET_ID__",
"type": "text",
"label": "Spreadsheet ID"
},
{
"name": "__SHEET__",
"type": "text",
"label": "Sheet"
},
{
"name": "0",
"type": "text",
"label": "A"
},
{
"name": "1",
"type": "text",
"label": "B"
},
{
"name": "2",
"type": "text",
"label": "C"
},
{
"name": "3",
"type": "text",
"label": "D"
},
{
"name": "4",
"type": "text",
"label": "E"
},
{
"name": "5",
"type": "text",
"label": "F"
},
{
"name": "6",
"type": "text",
"label": "G"
},
{
"name": "7",
"type": "text",
"label": "H"
},
{
"name": "8",
"type": "text",
"label": "I"
},
{
"name": "9",
"type": "text",
"label": "J"
},
{
"name": "10",
"type": "text",
"label": "K"
},
{
"name": "11",
"type": "text",
"label": "L"
},
{
"name": "12",
"type": "text",
"label": "M"
},
{
"name": "13",
"type": "text",
"label": "N"
},
{
"name": "14",
"type": "text",
"label": "O"
},
{
"name": "15",
"type": "text",
"label": "P"
},
{
"name": "16",
"type": "text",
"label": "Q"
},
{
"name": "17",
"type": "text",
"label": "R"
},
{
"name": "18",
"type": "text",
"label": "S"
},
{
"name": "19",
"type": "text",
"label": "T"
},
{
"name": "20",
"type": "text",
"label": "U"
},
{
"name": "21",
"type": "text",
"label": "V"
},
{
"name": "22",
"type": "text",
"label": "W"
},
{
"name": "23",
"type": "text",
"label": "X"
},
{
"name": "24",
"type": "text",
"label": "Y"
},
{
"name": "25",
"type": "text",
"label": "Z"
}
],
"type": "collection",
"label": "Values"
}
]
}
}
],
"metadata": {
"instant": false,
"version": 1,
"scenario": {
"roundtrips": 1,
"maxErrors": 3,
"autoCommit": true,
"autoCommitTriggerLast": true,
"sequential": false,
"slots": null,
"confidential": false,
"dataloss": false,
"dlq": false,
"freshVariables": false
},
"designer": {
"orphans": []
},
"zone": "eu2.make.com",
"notes": []
}
}