Custom Web ADI (Download/Upload)

Now we will integrate the download and upload ADIs. We will use the same custom table and packaged procedure used separately in download and upload.

Responsibility: Desktop Integration Manager

> Create Integrator

 XXAK: Test Web ADI

XXAKTESTWEBADI

Check the box for ‘Display in Create Document Page’

Add these three functions

Code:

BNE_ADI_DEFINE_MAPPING

BNE_CREATE_DOCUMENT

BNE_ADI_CREATE_DOCUMENT

Interface type here would be ‘API Procedure’

Package Name: xxak_testadi_pkg

Procedure/Function Name: load_record

API Returns : Error Message

Apply

You can click on ‘Update’ and change prompt and other details required

Create Content

Content type would be ‘SQL Query’

Query : SELECT order_number

      ,start_date

      ,end_date

      ,business_area

      ,batch_number

      ,status

  FROM XXAK_WEB_ADI_DOWNLAOD_TBL

Test Query

Apply

Create Uploader

Uploader: From Template

Select check boxes as below

Skip ‘Create Importer’

Submit

Define Layout

Navigation: Desktop Integrator -> Define Layout -> Select the Integrator

Go > Create

Change the Placement to 'Line'

Next

Apply

Create Mapping

Responsibility: Desktop Integrator

        > Define Mapping

• Mapping between ‘Interface’ and ‘Content’ data

Apply

Add a form function and add to specified responsibility menu

Responsibility: Application Developer

           > Application > Function

Type: SSWA servlet function
HTML Call: BneApplicationService

Parameter: bne:page=BneCreateDoc&bne:integrator=20003:XXAKTESTWEBADI_XINTG&bne:layout=20003:XXAKTESTWEBADI

select integrator_app_id || ':' || integrator_code integrator

     , application_id || ':' || layout_code layouts

  from bne_layouts_b

 where integrator_code like 'XXAK%'

Add this Function to the specified Menu and go to the related responsibility

Create Document