Import journal entries

Add MCP server to your AI tool

Allow AI tools and LLMs to interact with the API documentation portal through MCP.

MCP server URL

https://restapi.wyzio.com/mcp

Standard setup for AI tools providing an mcp.json file

mcp.json 
{
  "Wyzio MCP server": {
    "url": "https://restapi.wyzio.com/mcp"
  }
}
Close
POST /api-v1/journal/import

Imports journal entries from an uploaded file. Returns the list of imported entries.

Headers

  • WEAL-TOKEN Required

    API token (can be retrieved from account settings)

  • TARGET-ORGANIZATION-ID

    ID of organization, for which the operation must be performed

multipart/form-data

Body

  • file string(binary) Required

    Excel file (.xlsx) to import

Responses

  • 200 application/json

    OK

    Hide response attributes Show response attributes object
    • id integer(int64)
    • organizationId integer(int64)
    • entryId integer(int64)
    • entryDate string
    • description string Required

      Minimum length is 1.

    • amount number
    • journalLines array[object]
      Hide journalLines attributes Show journalLines attributes object
      • id integer(int64)
      • journalEntryId integer(int64)
      • accountId integer(int64) Required
      • accountNumber integer(int64)
      • description object
        Hide description attributes Show description attributes object
        • en string
        • fr string
        • de string
        • it string
      • accountCurrencyId integer(int64)
      • accountCurrencyCode string
      • foreignCurrencyId integer(int64)
      • foreignCurrencyCode string
      • accountDebit string

        Numeric value represented as string

      • accountCredit string

        Numeric value represented as string

      • foreignDebit string

        Numeric value represented as string

      • foreignCredit string

        Numeric value represented as string

      • companyDebit string

        Numeric value represented as string

      • companyCredit string

        Numeric value represented as string

      • departmentId integer(int64)
      • departmentName string
      • contactId integer(int64)
      • contactName string
      • orderId integer(int64)
      • orderIdToDisplay string
      • articleId integer(int64)
      • articleIdToDisplay object
        Hide articleIdToDisplay attributes Show articleIdToDisplay attributes object
        • en string
        • fr string
        • de string
        • it string
      • vatCodes array[object]
        Hide vatCodes attributes Show vatCodes attributes object
        • id integer(int64)
        • code string
        • title object
          Hide title attributes Show title attributes object
          • en string
          • fr string
          • de string
          • it string
        • countryId integer(int64)
        • startDate string
        • endDate string
        • effectiveDate string
      • vatCodesConcatenated object
        Hide vatCodesConcatenated attributes Show vatCodesConcatenated attributes object
        • en string
        • fr string
        • de string
        • it string
      • accountName object
        Hide accountName attributes Show accountName attributes object
        • en string
        • fr string
        • de string
        • it string
      • officeId integer(int64)
      • officeName string
    • type string

      Values are OPENING, MANUAL, PURCHASE_INVOICE, SALES_INVOICE, SALARY_SLIP, STOCK, CLOSING, SYSTEM, SYSTEM_FX, SYSTEM_PFUV, or FIXED_ASSET.

    • warnings string
    • isUnmodifiable boolean
  • 400

    400 Bad Request

  • 401

    401 Unauthorized

  • 403

    403 Access Denied

  • 404

    404 Not Found

  • 500

    500 Internal Server Error

POST /api-v1/journal/import 
curl \
 --request POST 'https://wyzio.app/api-v1/journal/import' \
 --header "Content-Type: multipart/form-data" \
 --form "file=@file"
Response examples (200) 
[
  {
    "id": 42,
    "organizationId": 42,
    "entryId": 42,
    "entryDate": "string",
    "description": "string",
    "amount": 42.0,
    "journalLines": [
      {
        "id": 42,
        "journalEntryId": 42,
        "accountId": 42,
        "accountNumber": 42,
        "description": {
          "en": "string",
          "fr": "string",
          "de": "string",
          "it": "string"
        },
        "accountCurrencyId": 42,
        "accountCurrencyCode": "string",
        "foreignCurrencyId": 42,
        "foreignCurrencyCode": "string",
        "accountDebit": "100.55",
        "accountCredit": "100.55",
        "foreignDebit": "100.55",
        "foreignCredit": "100.55",
        "companyDebit": "100.55",
        "companyCredit": "100.55",
        "departmentId": 42,
        "departmentName": "string",
        "contactId": 42,
        "contactName": "string",
        "orderId": 42,
        "orderIdToDisplay": "string",
        "articleId": 42,
        "articleIdToDisplay": {
          "en": "string",
          "fr": "string",
          "de": "string",
          "it": "string"
        },
        "vatCodes": [
          {
            "id": 42,
            "code": "string",
            "title": {
              "en": "string",
              "fr": "string",
              "de": "string",
              "it": "string"
            },
            "countryId": 42,
            "startDate": "string",
            "endDate": "string",
            "effectiveDate": "string"
          }
        ],
        "vatCodesConcatenated": {
          "en": "string",
          "fr": "string",
          "de": "string",
          "it": "string"
        },
        "accountName": {
          "en": "string",
          "fr": "string",
          "de": "string",
          "it": "string"
        },
        "officeId": 42,
        "officeName": "string"
      }
    ],
    "type": "OPENING",
    "warnings": "string",
    "isUnmodifiable": true
  }
]