mod-finance-storage (v2)

https://github.com/folio-org/mod-finance-storage

Table of contents

mod-finance-storage (Transactions)

CRUD APIs used to manage transactions.

/finance-storage/transactions

Collection of transaction items.

GET /finance-storage/transactions

Get list of transactions

GET /finance-storage/transactions
Query Parameters
  • query: (string)

    A query expressed as a CQL string (see dev.folio.org/reference/glossary#cql) using valid searchable fields. The first example below shows the general form of a full CQL query, but those fields might not be relevant in this context.

    with valid searchable fields: for example code

    Example:

    (username=="ab*" or personal.firstName=="ab*" or personal.lastName=="ab*") and active=="true" sortby personal.lastName personal.firstName barcode

["code", "MEDGRANT", "="]
  • offset: (integer - default: 0 - minimum: 0 - maximum: 2147483647)

    Skip over a number of elements by specifying an offset value for the query

    Example:

    0
  • limit: (integer - default: 10 - minimum: 0 - maximum: 2147483647)

    Limit the number of elements returned in the response

    Example:

    10
  • lang: (string - default: en - pattern: [a-zA-Z]{2})

    Requested language. Optional. [lang=en]

Response 200

Returns a list of transaction items

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A collection of transactions",
  "type": "object",
  "properties": {
    "transactions": {
      "description": "The list of objects contained in this collection",
      "type": "array",
      "id": "transactions",
      "items": {
        "type": "object",
        "$ref": "transaction.json"
      }
    },
    "totalRecords": {
      "description": "The number of objects in this collection",
      "type": "integer"
    }
  },
  "additionalProperties": false,
  "required": [
    "transactions",
    "totalRecords"
  ]
}

Example:

{
  "transactions": [
    {
      "id": "12Ac70A4-5C9D-112F-9aCB-852aDf67D7e1",
      "allocated": 0,
      "amount": 25,
      "awaitingPayment": 0,
      "encumbered": 25,
      "expenditures": 0,
      "note": "PO_Line: History of Incas",
      "timestamp": "2017-07-01T19:03:02.778Z",
      "sourceId": "906eb7a4-8BbC-1CCf-acAF-de909eABeedd",
      "transactionType": "PO-Line-Encumbrance",
      "budgetId": "47Ac60b4-159D-4e1c-9aCB-8293Df67D16d"
    }
  ],
  "totalRecords": 1
}

Response 400

Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.

Body

Media type: text/plain

Type: any

Example:

unable to list transactions -- malformed parameter 'query', syntax error at column 6

Response 401

Not authorized to perform requested action

Body

Media type: text/plain

Type: any

Example:

unable to list transactions -- unauthorized

Response 422

Validation errors

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A set of errors",
  "type": "object",
  "properties": {
    "errors": {
      "description": "List of errors",
      "id": "errors",
      "type": "array",
      "items": {
        "type": "object",
        "$ref": "error.schema"
      }
    },
    "total_records": {
      "description": "Total number of errors",
      "type": "integer"
    }
  }
}

Example:

{
  "errors": [
    {
      "message": "may not be null",
      "type": "1",
      "code": "-1",
      "parameters": [
        {
          "key": "moduleTo",
          "value": "null"
        }
      ]
    }
  ]
}

Response 500

Internal server error, e.g. due to misconfiguration

Body

Media type: text/plain

Type: any

Example:

internal server error, contact administrator

POST /finance-storage/transactions

Create a new transaction item.

POST /finance-storage/transactions
Query Parameters
  • lang: (string - default: en - pattern: [a-zA-Z]{2})

    Requested language. Optional. [lang=en]

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A financial transaction",
  "type": "object",
  "properties": {
    "id": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    },
    "allocated": {
      "description": "The amount allocated by this transaction",
      "type": "number"
    },
    "amount": {
      "description": "The amount of this transaction",
      "type": "number"
    },
    "available": {
      "description": "The amount available of this transaction",
      "type": "number"
    },
    "awaitingPayment": {
      "description": "The amount awaiting payment of this transaction",
      "type": "number"
    },
    "encumbered": {
      "description": "The amount encumbred by this transaction",
      "type": "number"
    },
    "expenditures": {
      "description": "The amount expended by this transaction",
      "type": "number"
    },
    "note": {
      "description": "The note for this transaction",
      "type": "string"
    },
    "overcharge": {
      "description": "The amount overcharged by this transaction",
      "type": "number"
    },
    "timestamp": {
      "description": "The timestamp of the transaction",
      "type": "string",
      "format": "date-time"
    },
    "sourceId": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    },
    "transactionType": {
      "description": "The type of this transaction",
      "type": "string"
    },
    "budgetId": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    }
  },
  "additionalProperties": false,
  "required": [
    "amount"
  ]
}

Example:

{
  "id": "12Ac70A4-5C9D-112F-9aCB-852aDf67D7e1",
  "allocated": 0,
  "amount": 25,
  "awaitingPayment": 0,
  "encumbered": 25,
  "expenditures": 0,
  "note": "PO_Line: History of Incas",
  "timestamp": "2017-07-01T19:03:02.778Z",
  "sourceId": "906eb7a4-8BbC-1CCf-bcAF-de909eABeedd",
  "transactionType": "PO-Line-Encumbrance",
  "budgetId": "47Ac60b4-159D-4e1c-9aCB-8293Df67D16d"
}

Response 201

Returns a newly created item, with server-controlled fields like 'id' populated

Headers
  • Location: required (string)

    URI to the created transaction item

Body

Media type: application/json

Type: any

Example:

{
  "id": "12Ac70A4-5C9D-112F-9aCB-852aDf67D7e1",
  "allocated": 0,
  "amount": 25,
  "awaitingPayment": 0,
  "encumbered": 25,
  "expenditures": 0,
  "note": "PO_Line: History of Incas",
  "timestamp": "2017-07-01T19:03:02.778Z",
  "sourceId": "906eb7a4-8BbC-1CCf-bcAF-de909eABeedd",
  "transactionType": "PO-Line-Encumbrance",
  "budgetId": "47Ac60b4-159D-4e1c-9aCB-8293Df67D16d"
}

Response 400

Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.

Body

Media type: text/plain

Type: any

Example:

"unable to add transaction -- malformed JSON at 13:3"

Response 401

Not authorized to perform requested action

Body

Media type: text/plain

Type: any

Example:

unable to create transactions -- unauthorized

Response 422

Validation errors

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A set of errors",
  "type": "object",
  "properties": {
    "errors": {
      "description": "List of errors",
      "id": "errors",
      "type": "array",
      "items": {
        "type": "object",
        "$ref": "error.schema"
      }
    },
    "total_records": {
      "description": "Total number of errors",
      "type": "integer"
    }
  }
}

Example:

{
  "errors": [
    {
      "message": "may not be null",
      "type": "1",
      "code": "-1",
      "parameters": [
        {
          "key": "moduleTo",
          "value": "null"
        }
      ]
    }
  ]
}

Response 500

Internal server error, e.g. due to misconfiguration

Body

Media type: text/plain

Type: any

Example:

Internal server error, contact administrator

GET /finance-storage/transactions/{id}

Retrieve transaction item with given {transactionId}

GET /finance-storage/transactions/{id}
URI Parameters
  • id: required (string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)

    The UUID of a transaction

Query Parameters
  • lang: (string - default: en - pattern: [a-zA-Z]{2})

    Requested language. Optional. [lang=en]

Response 200

Returns item with a given ID

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A financial transaction",
  "type": "object",
  "properties": {
    "id": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    },
    "allocated": {
      "description": "The amount allocated by this transaction",
      "type": "number"
    },
    "amount": {
      "description": "The amount of this transaction",
      "type": "number"
    },
    "available": {
      "description": "The amount available of this transaction",
      "type": "number"
    },
    "awaitingPayment": {
      "description": "The amount awaiting payment of this transaction",
      "type": "number"
    },
    "encumbered": {
      "description": "The amount encumbred by this transaction",
      "type": "number"
    },
    "expenditures": {
      "description": "The amount expended by this transaction",
      "type": "number"
    },
    "note": {
      "description": "The note for this transaction",
      "type": "string"
    },
    "overcharge": {
      "description": "The amount overcharged by this transaction",
      "type": "number"
    },
    "timestamp": {
      "description": "The timestamp of the transaction",
      "type": "string",
      "format": "date-time"
    },
    "sourceId": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    },
    "transactionType": {
      "description": "The type of this transaction",
      "type": "string"
    },
    "budgetId": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    }
  },
  "additionalProperties": false,
  "required": [
    "amount"
  ]
}

Example:

{
  "id": "12Ac70A4-5C9D-112F-9aCB-852aDf67D7e1",
  "allocated": 0,
  "amount": 25,
  "awaitingPayment": 0,
  "encumbered": 25,
  "expenditures": 0,
  "note": "PO_Line: History of Incas",
  "timestamp": "2017-07-01T19:03:02.778Z",
  "sourceId": "906eb7a4-8BbC-1CCf-bcAF-de909eABeedd",
  "transactionType": "PO-Line-Encumbrance",
  "budgetId": "47Ac60b4-159D-4e1c-9aCB-8293Df67D16d"
}

Response 404

Item with a given ID not found

Body

Media type: text/plain

Type: any

Example:

"transaction not found"

Response 422

Validation errors

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A set of errors",
  "type": "object",
  "properties": {
    "errors": {
      "description": "List of errors",
      "id": "errors",
      "type": "array",
      "items": {
        "type": "object",
        "$ref": "error.schema"
      }
    },
    "total_records": {
      "description": "Total number of errors",
      "type": "integer"
    }
  }
}

Example:

{
  "errors": [
    {
      "message": "may not be null",
      "type": "1",
      "code": "-1",
      "parameters": [
        {
          "key": "moduleTo",
          "value": "null"
        }
      ]
    }
  ]
}

Response 500

Internal server error, e.g. due to misconfiguration

Body

Media type: text/plain

Type: any

Example:

internal server error, contact administrator

DELETE /finance-storage/transactions/{id}

Delete transaction item with given {transactionId}

DELETE /finance-storage/transactions/{id}
URI Parameters
  • id: required (string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)

    The UUID of a transaction

Query Parameters
  • lang: (string - default: en - pattern: [a-zA-Z]{2})

    Requested language. Optional. [lang=en]

Response 204

Item deleted successfully

Response 400

Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.

Body

Media type: text/plain

Type: any

Example:

"unable to delete transaction -- constraint violation"

Response 404

Item with a given ID not found

Body

Media type: text/plain

Type: any

Example:

"transaction not found"

Response 422

Validation errors

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A set of errors",
  "type": "object",
  "properties": {
    "errors": {
      "description": "List of errors",
      "id": "errors",
      "type": "array",
      "items": {
        "type": "object",
        "$ref": "error.schema"
      }
    },
    "total_records": {
      "description": "Total number of errors",
      "type": "integer"
    }
  }
}

Example:

{
  "errors": [
    {
      "message": "may not be null",
      "type": "1",
      "code": "-1",
      "parameters": [
        {
          "key": "moduleTo",
          "value": "null"
        }
      ]
    }
  ]
}

Response 500

Internal server error, e.g. due to misconfiguration

Body

Media type: text/plain

Type: any

Example:

Internal server error, contact administrator

PUT /finance-storage/transactions/{id}

Update transaction item with given {transactionId}

PUT /finance-storage/transactions/{id}
URI Parameters
  • id: required (string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)

    The UUID of a transaction

Query Parameters
  • lang: (string - default: en - pattern: [a-zA-Z]{2})

    Requested language. Optional. [lang=en]

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A financial transaction",
  "type": "object",
  "properties": {
    "id": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    },
    "allocated": {
      "description": "The amount allocated by this transaction",
      "type": "number"
    },
    "amount": {
      "description": "The amount of this transaction",
      "type": "number"
    },
    "available": {
      "description": "The amount available of this transaction",
      "type": "number"
    },
    "awaitingPayment": {
      "description": "The amount awaiting payment of this transaction",
      "type": "number"
    },
    "encumbered": {
      "description": "The amount encumbred by this transaction",
      "type": "number"
    },
    "expenditures": {
      "description": "The amount expended by this transaction",
      "type": "number"
    },
    "note": {
      "description": "The note for this transaction",
      "type": "string"
    },
    "overcharge": {
      "description": "The amount overcharged by this transaction",
      "type": "number"
    },
    "timestamp": {
      "description": "The timestamp of the transaction",
      "type": "string",
      "format": "date-time"
    },
    "sourceId": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    },
    "transactionType": {
      "description": "The type of this transaction",
      "type": "string"
    },
    "budgetId": {
      "type": ["string", "null"],
      "description": "UUID",
      "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[1-5][a-fA-F0-9]{3}-[89abAB][a-fA-F0-9]{3}-[a-fA-F0-9]{12}$"
    }
  },
  "additionalProperties": false,
  "required": [
    "amount"
  ]
}

Example:

{
  "id": "12Ac70A4-5C9D-112F-9aCB-852aDf67D7e1",
  "allocated": 0,
  "amount": 25,
  "awaitingPayment": 0,
  "encumbered": 25,
  "expenditures": 0,
  "note": "PO_Line: History of Incas",
  "timestamp": "2017-07-01T19:03:02.778Z",
  "sourceId": "906eb7a4-8BbC-1CCf-bcAF-de909eABeedd",
  "transactionType": "PO-Line-Encumbrance",
  "budgetId": "47Ac60b4-159D-4e1c-9aCB-8293Df67D16d"
}

Response 204

Item successfully updated

Response 400

Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.

Body

Media type: text/plain

Type: any

Example:

"unable to update transaction -- malformed JSON at 13:4"

Response 404

Item with a given ID not found

Body

Media type: text/plain

Type: any

Example:

"transaction not found"

Response 422

Validation errors

Body

Media type: application/json

Type: json

Content:

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "A set of errors",
  "type": "object",
  "properties": {
    "errors": {
      "description": "List of errors",
      "id": "errors",
      "type": "array",
      "items": {
        "type": "object",
        "$ref": "error.schema"
      }
    },
    "total_records": {
      "description": "Total number of errors",
      "type": "integer"
    }
  }
}

Example:

{
  "errors": [
    {
      "message": "may not be null",
      "type": "1",
      "code": "-1",
      "parameters": [
        {
          "key": "moduleTo",
          "value": "null"
        }
      ]
    }
  ]
}

Response 500

Internal server error, e.g. due to misconfiguration

Body

Media type: text/plain

Type: any

Example:

internal server error, contact administrator