Skip to content
Proud to collaborate with Microsoft for Startups

sap.fetch-journal-entries ​

Fetch one bounded page of SAP accounting-document line items

Fetch one page of journal-entry line items for a posting-date window.

Overview ​

PropertyValue
Workflow typeLinear
LibraryApp-sap
Version1.0

Input Schema ​

FieldTypeRequiredDefaultDescription
organization_uuiduuidYes—Authenticated organization UUID injected by the workflow boundary
connection_uuiduuidYes—Organization-scoped SAP CloudConnection UUID
workflow_run_idstringNo—Engine-stamped parent DAG run id
start_datestringYes—Inclusive posting-date window start (YYYY-MM-DD)
end_datestringYes—Inclusive posting-date window end (YYYY-MM-DD)
skipintegerNo0Zero-based OData $skip
topintegerNo100OData $top page size (1..1000)
company_codestringNo—Narrow to one company code

Output Schema ​

FieldTypeRequiredDefaultDescription
organization_uuiduuidYes—Authenticated organization UUID injected by the workflow boundary
connection_uuiduuidYes—Organization-scoped SAP CloudConnection UUID
workflow_run_idstringNo—Engine-stamped parent DAG run id
start_datestringYes—Inclusive posting-date window start (YYYY-MM-DD)
end_datestringYes—Inclusive posting-date window end (YYYY-MM-DD)
skipintegerNo0Zero-based OData $skip
topintegerNo100OData $top page size (1..1000)
company_codestringNo—Narrow to one company code
journal_entrieslistYes—Normalized accounting-document line items
record_countintegerYes—Records in THIS page, not the full window
sap_environmentstringNo—Which SAP data set the records came from: 'sandbox' (Business Accelerator Hub canned data) or 'live'. Sourced from the connection, never from caller input. Persisted evidence must be partitioned by this value.
fetched_atstringYes——
failure_reasonstringNo——
failure_typestringNo——
failed_actionstringNo——
failed_stepjsonNo——
failed_layerintegerNo——
failed_at_statestringNo——
errorstringNo——
error_typestringNo——
failed_atstringNo——
provider_request_refstringNo——
retryablebooleanNo——

States ​

StateInitialTerminalSuccessAuto-advanceDescription
initiatedYesNo—execute—
executingNoNo—complete—
completedNoYesYes——
failedNoYesNo——

State Diagram ​

Transitions ​

FromActionToDescription
initiatedexecuteexecuting—
executingcompletecompleted—
* (any state)failfailed—

Outcomes ​

OutcomeTypeDescriptionState Data Keys
fetchedSUCCESSJournal entries were fetched and normalizedjournal_entries, record_count, sap_environment
failedFAILUREThe fetch failedfailure_reason, failure_type, retryable

Business Errors ​

CodeMessage Template
SAP_ORGANIZATION_CONTEXT_INVALIDAuthenticated organization context is missing or does not match the workflow input
SAP_CONNECTION_NOT_FOUNDSAP connection {connection_uuid} was not found in the authenticated organization
SAP_CONNECTION_WRONG_PROVIDERConnection {connection_uuid} is not a SAP connection
SAP_CONNECTION_SERVICE_UNAVAILABLEThe shared cloud connection service is unavailable
SAP_PROVIDER_CAPABILITY_MISSINGThe installed SAP provider does not expose the required API operation
SAP_AUTHENTICATION_FAILEDSAP rejected the connection credentials or API key
SAP_PROVIDER_REQUEST_FAILEDThe SAP OData request failed
SAP_RESPONSE_SHAPE_INVALIDThe SAP OData API returned an invalid response
SAP_PAGINATION_INVALIDskip must be a non-negative integer and top must be between 1 and 1000
SAP_WINDOW_INVALIDDates must use YYYY-MM-DD and be ordered
SAP_SIDE_INVALIDside must be exactly 'receivable' or 'payable'
SAP_ENVIRONMENT_INVALIDThe connection's SAP environment must be exactly 'sandbox' or 'live'

API Usage ​

bash
POST /api/workflows/start
Content-Type: application/json

{
  "workflow_type": "sap.fetch-journal-entries",
  "initial_data": {
    "organization_uuid": "value",
    "connection_uuid": "value",
    "start_date": "value",
    "end_date": "value"
  }
}