Microservice API Analysis for Reporting

Work in Progress

This is a work in progress and we will remove this info box when complete.

The OpenLMIS reporting architecture requires an understanding of the service APIs in order to better understand which components of the system should be considered for ingestion. This document is a large scope based on the OpenLMIS v3.3 architecture and includes identifying each microservice, taking a snapshot of the API endpoint, identifying if data changes over time and identifying whether this endpoint needs to be considered for reporting ingestion. Further documentation is available on the components page.

What's included:

  • All endpoints that have a GET method

What's not included:

  • Auth Service - The auth service focuses on authenticating users. The reporting stack does not have a clear use case for this information.
  • Reference UI - The reference UI component does not have endpoints that can be consumed.
  • Report Service - The report service primarily focuses on building reports for consumption within the Reference UI. There is no clear use case for this information.
  • Notification Service - The notification service only presents an interface for other microservices to send notifications to users. There is no clear use case for this information.
  • Endpoints with POST, PUT or DELETE methods will not be included because the reporting stack only consumes data.

Fulfillment Service

Fulfillment Service provides RESTful API endpoints for orders, shipments, and proofs of delivery. It supports fulfillment within OpenLMIS as well as external fulfillment using external ERP warehouse systems.

Resource
/api/
DescriptionFrequency
of Change

Consider
For Ingestion?

Notes
orderFileTemplatesGet the template of the order fileRarely

No


orderNumberConfigurationsGet the configuration for the order numberRarely

No


ordersGet an array of all orders. Minimal order details are presentedFrequentlyYesThis endpoint is used to get a list of orders so we can query each order by id
orders/requestingFacilitiesReturn UUIDs of all the available, distinct requesting facilities.
The supplying facility when provided, it will also filter the available requesting facilities by the supplying facility of the order.
RarelyNoThis may be interesting for streamlined reporting, but if we are consuming each order, we can derive this list in the reporting system.
orders/{id}Get chosen order with detailsFrequentlyYesThis Entity changes over time as orders change.
Note that there is an "expand" query parameter that could be valuable as well.
orders/{id}/exportExport order to CSVFrequentlyNo
orders/{id}/retryManually retry for transferring order file via FTP after updating or checking the FTP transfer properties.RarelyNo
orders/{id}/printPrint all order line items from an order to a csv or pdf file.FrequentlyNo
proofOfDeliveryTemplatesDownload proof of delivery report template with jrxml format.RarelyNo
proofsOfDeliveryGet an array of proofs of delivery.FrequentlyYesThis endpoint is used to get a list of all proofs of delivery so we can query each proof of delivery by id
proofsOfDelivery/{id}Get chosen proof of deliveryFrequentlyYesThis Entity changes over time as proofsOfDelivery change.
Note that there is an "expand" query parameter that could be valuable as well.
proofsOfDelivery/{id}/auditLogReturns all or part of the resource's audit logFrequentlyYesThis will be valuable for seeing how a proof of delivery has changed over time.
proofsOfDelivery/{id}/printPrint proof of delivery to a pdf file. RarelyNo
reports/templates/fulfillmentGet an array of all fulfillment report templatesRarelyYesThis gets a list of all report templates. This may be useful if we need to display any information to users in a similar way.
reports/templates/fulfillment/{id}Get a specific report templateRarelyYes
shipmentDraftsGet an array of all shipment drafts, which are shipment files that have not been submitted.FrequentlyNo
shipmentDrafts/{id}Get a specific shipment draftFrequentlyNo
shipmentsGet an array of all shipmentsFrequentlyYesThis endpoint is used to get a list of all shipments so we can query each shipment by id
shipments/{id}Get a specific shipmentFrequentlyYesThis Entity changes over time as shipments change.
Note that there is an "expand" query parameter that could be valuable as well.
transferProperties/searchFind transfer properties by facility id (transferProperties are used for FTP and local settings that help the system interact with a third party fulfillment service)RarelyNo
transferProperties/{id}Get a specific transfer propertyRarelyNo

CCE Service

The Cold Chain Equipment (CCE) Service provides RESTful API endpoints for managing a CCE catalog, inventory (tracking equipment at locations) and functional status. The catalog can use the WHO PQS.

Resource
/api/
Description

Frequency
of Change

Consider
For Ingestion?
Notes
catalogItemsReturns all CCE catalog items that are matching given request parameters by conjunction.InfrequentlyInThis endpoint is used to get a list of all catalog items so we can query each catalog item by id 
catalogItems/{id}Get a specific CCE catalog itemFrequentlyYesThis Entity changes over time as the CCE item reports it's status
cceAlertsGet an array of all CCE alertsFrequentlyYes
DeviceGet local resources (like inventory items) as FHIR Device instances.InfrequentlyYesWe should consider this if we wish to consume FHIR resources compared to catalogItems/{id}
Note that this just lists the device specifics, not the status.
inventoryItemsGet an array of all CCE inventory itemsInfrequentlyYesThis endpoint is used to get a list of all inventory items so we can query each inventory item by id
inventoryItems/{id}Get a specific CCE inventory itemFrequentlyYesThis Entity changes over time as the inventory item is updated.
cceGet the version of the CCE endpointInfrequentlyRarely

Reference Data Service

The Reference Data Service provides RESTful API endpoints that provide master lists of reference data including users, facilities, programs, products, schedules, and more. Most other OpenLMIS services depend on Reference Data Service. Many of these master lists can be loaded into OpenLMIS in bulk using the Reference Data Seed Tool or can be added and edited individually using the Reference Data Service APIs.

Resource
/api/
DescriptionFrequency
of Change
Consider
For Ingestion?
IngestedNotes
commodityTypesReturns an array of all commodityTypes in the systemInfrequentlyYesYesThis endpoint is used to get a list of all commodityTypes so we can query each commodityType by id
commodityTypes/{id}Returns a specific commodity typeInfrequentlyYesNot Needed(Not currently in the API documentation)
commodityTypes/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyYesNot NeededThis could help us parse changes to the commodityType
commodityTypes/{id}/tradeItemsReturns an array of Trade Item UUIDs that may fulfill for the given commodityTypeFrequentlyYesNot Needed
currencySettingsReturns the currency settings for OpenLMISRarelyNo

facilitiesReturns an array of facilities.InfrequentlyYesYes
facilities/minimalReturns an array of facilities with id and name onlyInfrequentlyNoNot Needed
facilities/supplyingReturns an array of facilities that are supplied by the same supervisory nodeInfrequentlyNo
(This API endpoint has poor documentation and no schema)
facilities/{id}Returns a specific facilityInfrequentlyYesNot Needed
facilities/{id}/approvedProductsReturns an array of full or non-full supply approved products for this facilityRarelyYes

facilities/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyYesNot Needed

This could help us understand the changes to a particular facility over time

facilityOperatorsReturns an array of all facility operatorsRarelyYesNot Needed
facilityOperators/{id}Returns a specific facility operatorRarelyYesNot Needed
facilityOperators/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyYesNot Needed
facilityTypeApprovedProductsReturns an array of approved products by facility typeInfrequentlyNo

facilityTypeApprovedProducts/{id}Returns a specific facility type approved productInfrequentlyNo

facilityTypeApprovedProducts/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyNo

facilityTypesReturns an array of facilityTypesRarelyYesNot Needed
facilityTypes/{id}Returns a specific facility typeRarelyYesNot Needed
facilityTypes/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
geographicLevelsReturns an array of geographicLevelsRarelyYesYes
geographicLevels/{id}Returns a specific geographic levelRarelyYesNot Needed
geographicLevels/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
idealStockAmountsReturns an array of idealStockAmountsRarelyYesYesThis may change quarterly or annually depending on the country's policy
LocationGet local resources (like geographic zones, facilities) as FHIR Location instances.InfrequentlyYesNot NeededWe may want to ingest this if we want to ingest FHIR resources. Otherwise, all information is available in other resources.
lotsExperimental resource to find lots in the systemFrequentlyYesYesWe will not ingest this endoint until it's no longer experimental. (This resource does not have a schema)
lots/{id}Experimental resource to find a specific lotFrequentlyNoNot NeededWe will not ingest this endoint until it's no longer experimental. (This resource does not have documentation)
lots/{id}/auditLogExperimental resource to get all or part of hte resource's audit logFrequentlyNoNot NeededWe will not ingest this endoint until it's no longer experimental.
orderableDisplayCategoriesReturns an array of orderableDisplayCategoriesInfrequentlyNoNot NeededWe need to review this. I'm not sure how it's used.
orderableDisplayCategories/searchFind orderable categories with matched code. Returns an array.InfrequentlyNoNot NeededThis resource uses a GET method and all other search endpoints use a POST method
orderableDisplayCategories/{id}Returns a specific orderable display categoryInfrequentyNoNot Needed
orderableDisplayCategories/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyNoNot Needed
processingPeriodsGet all processing periods that match the given parameters. The processingScheduleId parameter should not be used together with facilityId and programId parameters because all of them are used to find a processing schedule. Also the facilityId and programId parameters must be used together. This returns an array.RarelyYesYesThis changes annually depending on the country's policy
processingPeriods/{id}Returns a specific processing periodRarelyYesNot Needed
processingPeriods/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
processingPeriods/{id}/durationReturns an integer of the total months in the processing periodRarelyYesNot Needed
processingSchedulesReturns an array of all processingSchedulesRarelyYesNot NeededThis resource does not have a schema. We need to review this. I'm not sure how it's used.
processingSchedules/searchRetrieve processing schedule based on the provided parameters.RarelyNoNot NeededThis resource uses a GET method and all other search endpoints use a POST method
processingSchedules/{id}Returns a specific processing scheduleRarelyYesNot Needed
processingSchedules/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
programsReturns an array of all programsRarelyYesyes
programs/searchReturns an array of programsRarelyNoNot NeededThis resource uses a GET method and all other search endpoints use a POST method
programs/{id}Returns a specific programRarelyYesNot Needed
programs/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
requisitionGroupsReturns an array of requisitionGroupsRarelyYesYesThis resource does not have a schema.
requisitionGroups/{id}Returns a specific requisition groupRarelyYesNot Needed
requisitionGroups/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
rightsReturns an array of user rights (permissions)RarelyYesYesYes, assuming we need to replicate rights in the reporting stack.
rights/searchReturns an array of user rights based on search criteriaRarelyNoNot NeededThis resource uses a GET method and all other search endpoints use a POST method
rights/{id}Returns a specific user rightRarelyYes
Not enough rights to access the endpoint with administrator credentials.
rights/{id}/auditLogReturns all or part of the resource's audit logRarelyYes

rolesReturns an array of user rolesRarelyYesYesYes, assuming we need to replicate rights in the reporting stack.
roles/{id}Returns a specific user roleRarelyYesNot NeededThe documentation has this resource listed as /roles/{roleId} which doesn't follow the other syntax
roles/{id}/auditLogReturns all or part of the resource's audit logRarelyYes

serviceAccounts/{token}Returns a specific service accountFrequentlyNoNot Needed
stockAdjustmentReasonsReturns an array of stockAdjustmentReasonsRarelyYesNot Needed
stockAdjustmentReasons/searchReturns an array of stockAdjustmentReasons based on search criteriaRarelyNoNot Needed
stockAdjustmentReasons/{id}Returns a specific stock adjustment reasonRarelyYesNot Needed
stockAdjustmentReasons/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
supervisoryNodesReturns an array of supervisoryNodesRarelyYes

supervisoryNodes/{id}Returns a specific supervisory nodeRarelyYesNot Needed
supervisoryNodes/{id}/supervisoryUsersReturns a specific supervisory nodeInfrequentlyNoNot Needed
supervisoryNodes/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
supplyLinesReturns an array of supplyLinesRarelyYes

supplyLines/searchByUUIDReturns an array of supplyLines based on search criteriaRarelyNoNot NeededThis resource uses a GET method and all other search endpoints use a POST method
supplyLines/{id}Returns a specific supply lineRarelyYesNot Needed
supplyLines/{id}/auditLogReturns all or part of the resource's audit logRarelyYesNot Needed
tradeItemsReturns an array of tradeItemsInfrequentlyYesYes
tradeItems/{id}Returns a specific trade itemInfrequentlyYesNot NeededThis resource is not documented
tradeItems/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyYesNot Needed
usersReturns an array of usersInfrequently
Yes
users/rightSearchReturns an array of users based on search criteriaInfrequentlyNoNot Needed
users/{id}Returns a specific userInfrequentlyYesFutureThis resource is not documented and may not exist due to the /users/{userId} endpoint.
users/{id}/auditLogReturns all or part of the resource's audit logInfrequentlyYesFuture
users/{userId}Returns a specific userInfrequentlyYesFutureThis assumes we need to consumer user in
users/{userId}/facilitiesReturns an array of all supervision facilities associated with a user. To determine which facilities work with which right and program, please use /permissionStrings for mappings.InfrequentlyYesFuture
users/{userId}/fulfillmentFacilitiesReturns an array of facilities the associated user can fulfill.InfrequentlyYesFuture
users/{userId}/hasRightReturns a Boolean. Check if the user has a right with certain criteria.InfrequentlyYesFuture
users/{userId}/permissionStringsReturns an array of all permissions (in string format) associated with a user. The format is as follows; RightName|FacilityUUID|ProgramUUID for supervision rights, RightName|FacilityUUID for fulfillment rights, and RightName for general rights.InfrequentlyYesFuture
users/{userId}/programsReturns an array of programs the associated user supervises.InfrequentlyYesFuture
users/{userId}/roleAssignmentsReturns an array of full information about user's roles and rights.InfrequentlyYesFuture
users/{userId}/supervisedFacilitiesDepricatedInfrequentlyNoFuture
users/{userId}/supportedProgramsReturns an array of supported programs the associated user supervises through the home facility.InfrequentlyYesFuture

Requisition Service

The Requisition Service provides RESTful API endpoints for a robust requisition workflow used in pull-based supply chains for requesting more stock on a schedule through an administrative hierarchy. Requisitions are initiated, filled out, submitted, and approved based on configuration. Requisition Templates control what information is collected on the Requisition form for different programs and facilities.

Resource
/api/
DescriptionFrequency
of Change
Consider
For Ingestion?
Notes
availableRequisitionColumnsReturns an array of availableRequisitionColumnsRarelyYesYes, assuming we want to dynamically display requisition information
reports/templates/requisitionsReturns an array of requisition report templatesRarelyNo
reports/templates/requisitions/{id}Returns a specific requisition report templateRarelyNo
reports/templates/requisitions/{id}/{format}Returns a generated report based on the template id and formatRarelyNo
requisitionsReturns an array of requisitionsFrequentlyYes
requisitions/periodsForInitiateReturns a single processing period DTO that's available to initiate the requisitionFrequentlyNo
requisitions/requisitionsForApprovalReturns an array of requisitions that are currently awaiting approvalFrequentlyYes
requisitions/requisitionsForConvertReturns an array of requisitions that are currently awaiting to be converted to ordersFrequentlyYes
requisitions/searchReturns an array of requisitions based on search criteriaFrequentlyNoThis resource uses a GET method and all other search endpoints use a POST method
requisitions/submittedReturns an array of requisitions that currently have "SUBMITTED" statusFrequentlyYes
requisitions/{id}Returns a specific requisitionFrequentlyYes
requisitions/{id}/printReturns a PDF of a specific requisitionFrequentlyNo
requisitions/{id}/statusMessagesReturns an array of status messages for a specific requisitionFrequentlyNo
requisitiontemplatesReturns an array of requisitionTemplatesRarelyYes
requisitiontemplates/{id}Returns a specific requsitionTemplateRarelyYes

Stock Management Service

The Stock Management Service provides RESTful API endpoints for creating electronic stock cards and recording stock transactions over time.

Resource
/api/
DescriptionFrequency
of Change
Consider
For Ingestion?
Notes
organizationsReturns an array of organizations.
This is for administrators only.
It requires the permission STOCK_ORGANIZATIONS_MANAGE.
Regular users can get the list of sources or destinations they can use through /api/validSources and /api/validDestinations.
RarelyNo
physicalInventoriesReturns an array of saved physical inventory. If inventories do not exist, will return empty list.FrequentlyYes
physicalInventories/{id}Returns a specific physical inventoryFrequentlyYes
physicalInventoryTemplatesReturns a jrxml physical inventory report templateRarelyNo
reasonCategoriesReturns an array of reason categories to choose from, for admin user to configure reasons.RarelyYes
reasonTypesReturns an array of reason types to choose from, for admin user to configure reasons.RarelyYes
stockCardLineItemReasonsReturns an array of stockCardLineItemReasonsRarelyYes
stockCardLineItemReasons/{id}Returns a specific stock card line item reasonRarelyYes
stockCardLineItemReasonTagsReturns an array of stockCardLineItemReasonTagsRarelyNo
stockCardsReturns an array of stock cards, result is an intersection of user rights and request parameters.FrequentlyYes
stockCards/{id}Returns a specific stock cardFrequentlyYes
stockCards/{id}/printReturns a PDF of the stock cardFrequentlyNo
stockCardSummariesDepricatedFrequentlyNo
stockCardSummaries/printReturns a stock card summary report in PDF format to print.FrequentlyNo
stockCardSummaries/noCardsReturns an array of dummy stock card summaries for approved products and lots that don't have cards yet. This can be used by front end to determine what new stock cards can be created.RarelyNo
stockCardTemplatesReturns a stock card template given the parametersRarelyNoI think this is used for UI related display and may be applicable for display in the reporting stack
v2/stockCardSummariesReturns an array of summaries of stock cards, which contains SOH, product name, and other essential information. This will NOT return any line items. (This could be used by front end for list view.)FrequentlyYes
validDestinationsReturns an array of valid destinations of a program and a facility type.RarelyYes
validReasonsReturns an array of valid reasons based on program and facility type.RarelyYes
validSourcesReturns an array of valid sources based on program and facility type.RarelyYes

Sample API Improvements from Ona

  1. For referenceData, having an API to accept a single /{id} for the 3 below, it would make it easier to fetch the ISA
    1. Facility
    2. Commodity type
    3. Processing period 
  2. Add field for updatedDate that would indicate the last time a transaction was updated. Particularly, the last time the stockOnHand was recalculated
    1. If a transaction has a postDate on the 5th of the month but an occurredDate on the 1st of the month, we know that transaction potentially affected all transactions for that orderable at that facility after the 1st of the month
    1. Right now all we have is occurred date, but when certain data points on a particular transaction can change over time, knowing the last time that transaction was updated would greatly assist us as we keep the stockOnHand field up to date. Without this, we need to reindex bulk data periodically to ensure SoH is accurate (which is not practical at all), or we would need to calculate SoH in the reporting platform.
    2. Alternative: add field for postDate
  3. Make “program” an optional parameter for stock cards so we don’t have to hit the API for each program.
    1. We would still extract the program information, but it wouldn’t be required by the API in order to fetch data.
    2. This reduces the number of times that we need to query the API
    3. We can expect up to 5 programs in an implementation
    4. The data that’s in reporting will retain the program
  4. Instead of listing the ids of Commodity Type, Trade Item, Facility, etc. on each stock card line item, list the name of those entities directly

OpenLMIS: the global initiative for powerful LMIS software