Navigation:  Integration via database > Published interfaces > Workspace >

GNCATALOGSERVICE - Service catalog service import

 Previous  Top  Next

This import template enables to insert/edit:

▪Data of a service from the service catalog.

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert - DIINTERFACE

Column

Required

Type

Precision

Description

OIDINTERFACE

X

TEXT

32

DIINTERFACE table registry key.

FGIMPORT

X

NUMERIC

2

Import status:

1 – New;

2 – In progress;

3 – Finished;

4 – Error.

CDISOSYSTEM

X

NUMERIC

10

System code where the integration will be performed to:

146 - SoftExpert Request component code.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

27 - Add service to the service catalog.

NMFIELD01

X

TEXT

10

Numeric catalog code. Such information can be found in the service catalog information section.

NMFIELD02

 

TEXT

255

Service name To inherit from the destination object, leave this column blank.

NMFIELD03

X

TEXT

50

Destination object type.

NMFIELD04

X

TEXT

50

Fill out this column with the destination object ID #.

NMFIELD05

 

TEXT

10

Numeric category code. Such information can be found in the service catalog category section. Separate with "," (comma) if you wish to define the service on more than one category.

NMFIELD06

 

TEXT

50

ID of the user that is performing the operation.

DSFIELD01

 

TEXT

4000

Service description. Use this column to add further details about the service.

 

Example of service insertion in the catalog:

INSERT INTO DIINTERFACE (OIDINTERFACE, FGIMPORT, CDISOSYSTEM, FGOPTION, NMFIELD01, NMFIELD02, NMFIELD03, NMFIELD04, NMFIELD05, NMFIELD06, DSFIELD01) VALUES (1, 1, 146, 27, 1, 'My service name', 'PROCESS', 'Process ID', 1, 'sesuite12', 'My service description');