GNCATALOGSERVICE - Import of service catalog services
This import template allows inserting/editing:
- Data of a service from the service catalog.
To insert each of these items, the standard documented below must be followed.
Insert​
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 | Code of the system in which the integration will be performed: 146 - Code of the SoftExpert Request component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 27 - Add service to service catalog. |
NMFIELD01 | X | TEXT | 10 | Catalog numeric code. This 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 this column with the destination object ID #. |
NMFIELD05 | TEXT | 10 | Category numeric code. This information can be found in the service catalog category section. Separate with "," (comma) if you wish to define the service in 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 give the user more 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');