Raiffeisenbank statements for PohodaSQL+Sharepoint Raiffeisenbank statements for PohodaSQL+Sharepoint
KeyTypeRequiredDescription
ACCOUNT_CURRENCYstringfor multicurrency accounts please specify one
ACCOUNT_NUMBERstringBank Account Number
APP_DEBUGboolShow debug messages
CERT_FILEstringPath to RB Certificate file
CERT_PASSpasswordCertificate password
CNB_CACHEstringUse CNB cache to get actual rate from CNB
DB_CONNECTIONstringDatabase Connection
DB_DATABASEstringDatabase Name
DB_HOSTstringDatabase Host
DB_PASSWORDpasswordDatabase Password
DB_PORTintegerDatabase Port
DB_SETTINGSstringDatabase Settings like encrypt=false
DB_USERNAMEstringDatabase Username
EASE_LOGGERstringwrite log messages using
FIXED_RATEintegerFixed rate for converting foreign currency transactions to CZK
FIXED_RATE_AMOUNTintegerFixed rate amount for some currencies (e.g., 💴)
IMPORT_SCOPEstringTime scope of transactions downloaded
OFFICE365_CLIENTIDstringOffice 365 Client ID
OFFICE365_CLSECRETstringOffice 365 Client Secret
OFFICE365_PASSWORDpasswordOffice 365 Password
OFFICE365_PATHstringOffice 365 Path
OFFICE365_SECRETstringOffice 365 Secret
OFFICE365_SITEstringOffice 365 Site
OFFICE365_TENANTstringOffice 365 Tenant
OFFICE365_USERNAMEstringOffice 365 Username
POHODA_BANK_IDSstringPohoda Bank IDs
POHODA_COMPRESSboolPohoda Compress
POHODA_DEBUGboolPohoda Debug
POHODA_TIMEOUTintegerPohoda Timeout
RATE_OFFSETstringRate offset to get rate for previous day
RBAPI_RATE_LIMIT_JSON_FILEstringwrite API rate limit file using
RESULT_FILEstringwrite output json data to
STATEMENT_LINEsetBank Statement line
STATEMENT_SAVE_DIRstringPlace for PDF files
XIBMCLIENTIDstringClientID
ZABBIX_KEYstringDefault name for Zabbix Item key name
Raiffeisenbank statements for PohodaSQL+Sharepoint
{
    $schema: "https:\/\/raw.githubusercontent.com\/VitexSoftware\/php-vitexsoftware-multiflexi-core\/refs\/heads\/main\/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.3.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"
            }
        }
    ]
}
Download raiffeisenbank_statements_for_pohodasql_sharepoint.multiflexi.app.json