{
$schema: "https:\/\/multiflexi.eu\/schema\/application.json",
image: "",
name: {
cs: "V\u00fdpisy Raiffeisenbank pro PohodaSQL a Sharepoint",
en: "Raiffeisenbank statements for PohodaSQL+Sharepoint"
},
description: {
cs: "Importujte v\u00fdpisy Raiffeisenbank do Pohody p\u0159es mServer a ulo\u017ete je do Sharepointu",
en: "Import Raiffeisenbank statements into Pohoda via mServer and store in Sharepoint"
},
executable: "pohodasql-raiffeisenbank-statements-sharepoint",
homepage: "https:\/\/github.com\/Spoje-NET\/pohoda-raiffeisenbank",
uuid: "e9893573-24aa-4518-bf05-66fae9ad153c",
tags: [
"Raiffeisen",
"Bank",
"Statements",
"Pohoda"
],
version: "1.7.1.222",
schemaVersion: "3.4.0",
requirements: [
"RaiffeisenBank",
"SQLServer",
"Office365",
"MServer"
],
environment: {
ACCOUNT_CURRENCY: {
type: "string",
description: "for multicurrency accounts please specify one",
defval: "",
required: false
},
ACCOUNT_NUMBER: {
type: "string",
description: "Bank Account Number",
defval: "",
required: true
},
APP_DEBUG: {
type: "bool",
description: "Show debug messages",
defval: "0",
required: false
},
CERT_FILE: {
type: "string",
description: "Path to RB Certificate file",
defval: "",
required: true
},
CERT_PASS: {
type: "password",
description: "Certificate password",
defval: "",
required: true
},
CNB_CACHE: {
type: "string",
description: "Use CNB cache to get actual rate from CNB",
defval: "http:\/\/localhost\/cnb-cache",
required: false
},
DB_CONNECTION: {
type: "string",
description: "Database Connection",
defval: "sqlsrv",
required: true
},
DB_DATABASE: {
type: "string",
description: "Database Name",
defval: "StwPh_12345678_2023",
required: true
},
DB_HOST: {
type: "string",
description: "Database Host",
defval: "127.0.0.1",
required: true
},
DB_PASSWORD: {
type: "password",
description: "Database Password",
defval: "",
required: true
},
DB_PORT: {
type: "integer",
description: "Database Port",
defval: "1433",
required: true
},
DB_SETTINGS: {
type: "string",
description: "Database Settings like encrypt=false",
defval: "",
required: false
},
DB_USERNAME: {
type: "string",
description: "Database Username",
defval: "sa",
required: true
},
EASE_LOGGER: {
type: "string",
description: "write log messages using",
defval: "console|syslog",
required: false
},
FIXED_RATE: {
type: "integer",
description: "Fixed rate for converting foreign currency transactions to CZK",
defval: "0",
required: false
},
FIXED_RATE_AMOUNT: {
type: "integer",
description: "Fixed rate amount for some currencies (e.g., \ud83d\udcb4)",
defval: "100",
required: false
},
IMPORT_SCOPE: {
type: "string",
description: "Time scope of transactions downloaded",
defval: "auto",
required: true
},
OFFICE365_CLIENTID: {
type: "string",
description: "Office 365 Client ID",
defval: "",
required: false
},
OFFICE365_CLSECRET: {
type: "string",
description: "Office 365 Client Secret",
defval: "",
required: false
},
OFFICE365_PASSWORD: {
type: "password",
description: "Office 365 Password",
defval: "",
required: false
},
OFFICE365_PATH: {
type: "string",
description: "Office 365 Path",
defval: "",
required: true
},
OFFICE365_SECRET: {
type: "string",
description: "Office 365 Secret",
defval: "",
required: false
},
OFFICE365_SITE: {
type: "string",
description: "Office 365 Site",
defval: "",
required: true
},
OFFICE365_TENANT: {
type: "string",
description: "Office 365 Tenant",
defval: "",
required: true
},
OFFICE365_USERNAME: {
type: "string",
description: "Office 365 Username",
defval: "",
required: false
},
POHODA_BANK_IDS: {
type: "string",
description: "Pohoda Bank IDs",
defval: "KB",
required: true
},
POHODA_COMPRESS: {
type: "bool",
description: "Pohoda Compress",
defval: "0",
required: false
},
POHODA_DEBUG: {
type: "bool",
description: "Pohoda Debug",
defval: "0",
required: false
},
POHODA_TIMEOUT: {
type: "integer",
description: "Pohoda Timeout",
defval: "60",
required: true
},
RATE_OFFSET: {
type: "string",
description: "Rate offset to get rate for previous day",
defval: "yesterday",
required: false
},
RBAPI_RATE_LIMIT_JSON_FILE: {
type: "string",
description: "write API rate limit file using",
defval: "{MULTIFLEXI_TMP}\/rbczpremiumapi_rates.json",
required: false
},
RESULT_FILE: {
type: "string",
description: "write output json data to",
defval: "bank_import_report_{ACCOUNT_NUMBER}.json",
required: false
},
STATEMENT_LINE: {
type: "set",
description: "Bank Statement line",
defval: "ADDITIONAL",
required: false
},
STATEMENT_SAVE_DIR: {
type: "string",
description: "Place for PDF files",
defval: "",
required: false
},
XIBMCLIENTID: {
type: "string",
description: "ClientID",
defval: "",
required: true
},
ZABBIX_KEY: {
type: "string",
description: "Default name for Zabbix Item key name",
defval: "Raiff-Import-{ACCOUNT_NUMBER}",
required: false
}
},
artifacts: [
{
name: {
cs: "Report importu",
en: "Import report"
},
path: "bank_import_report_{\\d+}.json$",
type: "file",
description: {
cs: "Stavy v\u00fdpisu: sta\u017een\u00ed z banky, import do pohody, nahr\u00e1t\u00ed do sharepointu, p\u0159\u00edloha linku do Pohody",
en: "Stauses of Statement: download from bank, import to Pohoda, upload to Shatepoint, Attachment link in Pohoda"
}
}
],
exitCodes: {
0: {
description: {
cs: "\u00dasp\u011b\u0161n\u00e9 dokon\u010den\u00ed",
en: "Success"
},
severity: "success",
retry: false
},
1: {
description: {
cs: "Obecn\u00e1 chyba",
en: "General error"
},
severity: "error",
retry: true
},
2: {
description: {
cs: "Chyba p\u0159i z\u00edsk\u00e1v\u00e1n\u00ed PDF v\u00fdpis\u016f z Raiffeisen Bank",
en: "Error obtaining PDF statements from Raiffeisen Bank"
},
severity: "error",
retry: true
},
3: {
description: {
cs: "Chyba p\u0159\u00edstupu k Pohoda mServer nebo z\u00edsk\u00e1v\u00e1n\u00ed XML v\u00fdpis\u016f",
en: "Error accessing Pohoda mServer or obtaining XML statements"
},
severity: "error",
retry: true
},
4: {
description: {
cs: "Nepoda\u0159ilo se p\u0159ipojit odkaz SharePoint k z\u00e1znamu banky v Pohod\u011b p\u0159es SQL",
en: "Failed to attach SharePoint URL to Pohoda bank record via SQL"
},
severity: "error",
retry: true
},
145: {
description: {
cs: "Chyba autentizace nebo certifik\u00e1tu Raiffeisen Bank API (HTTP 401 Unauthorized).",
en: "Raiffeisen Bank API authentication or certificate error (HTTP 401 Unauthorized)."
},
severity: "error",
retry: false
},
146: {
description: {
cs: "Certifik\u00e1t je neplatn\u00fd.",
en: "Certificate is invalid."
},
severity: "error",
retry: false
},
148: {
description: {
cs: "U\u017eivatel nem\u00e1 pr\u00e1va k proveden\u00ed operace.",
en: "No access rights to perform the operation."
},
severity: "error",
retry: false
},
149: {
description: {
cs: "Po\u017eadovan\u00fd zdroj neexistuje.",
en: "Requested resource does not exist."
},
severity: "error",
retry: false
},
158: {
description: {
cs: "T\u011blo po\u017eadavku je p\u0159\u00edli\u0161 velk\u00e9.",
en: "Request payload too large."
},
severity: "error",
retry: false
},
160: {
description: {
cs: "Nepodporovan\u00fd typ obsahu.",
en: "Unsupported media type."
},
severity: "error",
retry: false
},
174: {
description: {
cs: "P\u0159\u00edli\u0161 mnoho po\u017eadavk\u016f. Limit p\u0159ekro\u010den.",
en: "Too many requests. Rate limit exceeded."
},
severity: "warning",
retry: true
},
245: {
description: {
cs: "Neo\u010dek\u00e1van\u00e1 intern\u00ed chyba.",
en: "Unexpected internal error."
},
severity: "critical",
retry: false
}
}
}
Download raiffeisenbank_statements_for_pohodasql_sharepoint.multiflexi.app.json