Highlighted
Absent Member.. jowillia Absent Member..
Absent Member..
135 views

Push adapter mapping files - datatypes supported

Hello,

Does anyone have a full specification for the mapping files schema that includes all datatypes supported.

There is a KM KM02413843 indicating that BigInteger should be used and not integer, but I cannot find any references to all the types supported. For exmaple, in a push to ServiceNow, what is the correct datatype to use for a destination column with 'decimal' ?

Thanks,

John

0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

Re: Push adapter mapping files - datatypes supported

Hello John,

The basic source of information regarding to that integration is any recent version of the guide: "Discovery and Integrations Content Guide - Third Party Integrations", chapter - "ServiceNow Integration".

Regarding to the "decimal" type values that is not supported:
https://softwaresupport.hpe.com/group/softwaresupport/search-result/-/facetsearch/document/LID/QCCR1H81560

Best Regards,
Nikola

------------------------
Nikola Todorov
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Absent Member.. jowillia Absent Member..
Absent Member..

Re: Push adapter mapping files - datatypes supported

Hi

Thanks for the answer and link.

Actually I managed to fix this.  BigDecimal type is supported on the SN side.

If you add the type import to the jython script on the uCMDB side, and then add a reference to it in processCIs, it works fine.

Modified sections of the script pasted below as I can't attach it..  (from java.math import BigDecimal)

Lines 557 to 561 set values using the type.

It answers the refrenced QCCR where the customer refered to cpu_speed mappings. Tested in uCMDB 10.22 CP20 against Helsinki version of SN.

John

-------------------------------

In the imports:

from java.math import BigDecimal

In function processCIs add this after line 556
elif fieldDataType == 'BigDecimal':
     if fieldValue:
        setValue(SNWebServiceAction, fieldName, BigDecimal(fieldValue), [BigDecimal])

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.