Versions Compared

Version Old Version 9 New Version 10
Changes made by

Deepak Kumar (Deactivated)

Subrat Sandilya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table Name: DB/file_queueFQ/

Expand
titleSQL Query

SELECT ID,FILE_QUEUE_ID,LOCATION_TYPE,FILE_TYPE,FILE_PATH,FILE_NAME,CREATED_BY,CREATED_DATE,LAST_MODIFIED_BY,LAST_MODIFIED_DATE FROM "file_name_details"

Expand
titleWhere Clause

WHERE FILE_QUEUE_ID =$$fileQueueId$$ and FILE_TYPE IN('ERROR_REPORT_FILE','V3_OUTPUT_FILE','FILTERED_PRODUCTS_LIST','DBQUERY_FILE','EBMR_OUTPUT_FILE')

  1. Stream Selector - Use the Steam selector to specify the input stream to be consumed by the activity when there are two sources (DB).

...

  1. Target Layout - The JSON schema for the source data (database) will be designed to be utilized in the RESTful API for the user interface. JSON is selected for its compatibility with RESTful APIs.

...

  1. Mapping - Load the database schema and the target schema (JSON) to do one-to-one mapping.

    1. Apply the for each loop to fetch the data one by one.

...

  1. Context Target Using ContextTarget to store data in the flow which will be carried by the REST provider.

...

3. Create REST Provider End-point

...