search

sh977218 / ts-etl-ui

0 stars 0 forks source link

api integration view edit load request #409

Closed sh977218 closed 3 days ago

sh977218 commented 1 month ago

image

sh977218 commented 1 month ago

the API is not yet ready.

sh977218 commented 2 weeks ago

/load-request/{opRequestSeq} example response:

{
  "loadRequestRecord": {
    "requestId": 0,
    "codeSystemName": "string",
    "requestSubject": "string",
    "sourceFilePath": "string",
    "requestType": "string",
    "requester": "string",
    "requestTime": "2024-10-02T17:59:38.777Z",
    "creationTime": "2024-10-02T17:59:38.777Z",
    "requestStatus": "string",
    "numberOfMessages": 0,
    "loadNumber": 0,
    "loadStatus": "string",
    "loadStartTime": "string",
    "loadElapsedtime": "string"
  },
  "loadRequestMessageList": {
    "message_type": "string",
    "tag": "string",
    "message": "string",
    "creationTime": "string"
  },
  "componentActivityList": {
    "componentName": "string",
    "componentStatus": "string",
    "componentStartTime": "2024-10-02T17:59:38.777Z",
    "componentEndTime": "2024-10-02T17:59:38.777Z",
    "componentDuration": "string",
    "messageCount": 0
  },
  "componentMessageSummary": {
    "componentMessageRecord": {
      "searchColumns": {
        "componentName": "string",
        "messageGroup": "string",
        "messageType": "string",
        "messageTag": "string",
        "message": "string",
        "creationTime": "2024-10-02T17:59:38.777Z"
      },
      "pagination": {}
    },
    "componentMessage": {
      "componentName": "string",
      "messageGroup": "string",
      "messageType": "string",
      "messageTag": "string",
      "message": "string",
      "creationTime": "2024-10-02T17:59:38.777Z"
    }
  }
ludetc commented 2 weeks ago

I think they are making a mistake mixing multiple objects into one. But it is how it is. We can change our mock backend to retrieve from both LR and LV, and as you said, ObjectAssign.

sh977218 commented 2 weeks ago 
{
  "status": {
    "httpStatus": 201
  },
  "service": {
    "url": "/load-request/1041",
    "accessTime": "2024-10-03 14:40:45",
    "duration": 22
  },
  "result": {
    "data": {
      "loadRequestRecord": [
        {
          "opRequestSeq": 1041,
          "codeSystemName": "ATC",
          "requestSubject": "test",
          "sourceFilePath": "file://nlmsambaserver.nlm.nih.gov/dev-ts-data-import/ATC/ATC2024",
          "requestType": "Regular",
          "requestTime": "2024-10-03T16:59:42.949Z",
          "requester": "yakut1nala",
          "creationTime": "2024-10-03T16:59:42.000Z",
          "requestStatus": "Aborted",
          "numberOfMessages": 0,
          "loadNumber": null,
          "loadStatus": null,
          "loadTime": null,
          "loadDuration": "00:00:00"
        }
      ],
      "loadRequestMessageList": [],
      "componentActivityList": [
        {
          "componentName": "extract",
          "componentStatus": "Aborted",
          "componentStartTime": "2024-10-03T17:00:08.024Z",
          "componentEndTime": "2024-10-03T17:00:09.815Z",
          "componentDuration": "00:00:02",
          "messageCount": 1
        }
      ],
      "componentMessageList": [
        {
          "componentName": "extract",
          "messageGroup": "Error",
          "messageType": "CONFIG",
          "messageTag": "DUPLICATE_VERSION",
          "message": "This is an operational mistake. Same version should not be loaded twice",
          "creationTime": "2024-10-03T17:00:09.000Z"
        }
      ]
    },
    "hasPagination": false,
    "pagination": null
  }
}
sh977218 commented 1 week ago 
{
  "status": {
    "httpStatus": 201
  },
  "service": {
    "url": "/load-request/1042",
    "accessTime": "2024-10-10 08:44:27",
    "duration": 56
  },
  "result": {
    "data": {
      "loadRequestSummary": {
        "opRequestSeq": 1042,
        "codeSystemName": "ATC",
        "requestSubject": "aaaa",
        "sourceFilePath": "file://nlmsambaserver.nlm.nih.gov/dev-ts-data-import/CPT/CPT2024/",
        "requestType": "Regular",
        "requestTime": "2024-10-05T02:09:29.507Z",
        "requester": "Peter Huang",
        "requesterUsername": "peterhuang",
        "creationTime": "2024-10-05T02:09:29.000Z",
        "requestStatus": "Complete",
        "loadNumber": 20241004221009,
        "loadStatus": "Pending QA",
        "loadStartTime": "2024-10-05T02:10:10.000Z",
        "loadEndTime": "2024-10-05T02:12:26.639Z",
        "loadRequestMessageList": [
          {
          "messageType": "INFO",
           "tag": "ROW_TABLE_COUNT",
           "message": "some info on extraction",
           "creationTime": "2024-10-05T02:12:26.639Z"
          }
        ]
      },
      "loadComponentList": [
        {
          "componentName": "extract",
          "componentStatus": "Complete",
          "componentStartTime": "2024-10-05T02:10:08.758Z",
          "componentEndTime": "2024-10-05T02:10:14.041Z",
          "error": 1,
          "warning": 0,
          "info": 0
        },
        {
          "componentName": "assert",
          "componentStatus": "Complete",
          "componentStartTime": "2024-10-05T02:12:06.582Z",
          "componentEndTime": "2024-10-05T02:12:26.008Z",
          "error": 0,
          "warning": 0,
          "info": 0
        },
        {
          "componentName": "inject",
          "componentStatus": "Complete",
          "componentStartTime": "2024-10-05T02:11:06.573Z",
          "componentEndTime": "2024-10-05T02:11:08.320Z",
          "error": 0,
          "warning": 0,
          "info": 0
        }
      ],
      "loadComponentMessageList": [
        {
          "componentName": "extract",
          "messageGroup": "Error",
          "messageType": "SOURCE",
          "messageTag": "MISSING_DATA_FILE",
          "message": "A required \"^([0-9]{4}) ATC .+.xlsx\" data file is missing from the source folder",
          "creationTime": "2024-10-05T02:10:11.000Z"
        }
      ]
    }
  }
}