Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

REST Connector ImportAccountEntJson with text/xml format input

rushikeshvartak
All-Star
All-Star

Can saviynt consume data in text/xml format from target ? if yes what will be listfield & colsToPropMap

Any additional configurations needs to be done ?

rushikeshvartak_1-1655240710854.png

 

 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.
8 REPLIES 8

sagars
Saviynt Employee
Saviynt Employee

@rushikeshvartak ,

Yes our REST Connector supports xml format. You can use the online XML to JSON convertor to translate the response and then define the list path. colsToPropMap is similar to regular JSON import we use to do.

Only change will be the "httpContentType": "text/xml"

sagars_0-1655301788554.png

 

Regards,
Sagar Srikantaiah

rushikeshvartak
All-Star
All-Star

In colsToProp how much deep level we can go ?

for example. profile.email.value.value1 ?

XML :

<data description="Energy Components" sqlTime="2220953" inmemory="true" ecVersion="13.0.10" systemofmeasurement="" apiVersion="v1" daoTime="13501" presentationcontext="/rest">
<class name="T_BASIS_USER">
<property name="USER_ID" datarequired="true" sortheader="true" viewlabel="User Id" datatype="STRING" key="true" uniquekey="false" vieweditable="false"/>
<property name="USER_GROUP" datarequired="false" viewhidden="true" viewlabel="User Group" datatype="STRING" key="false" uniquekey="false"/>
</class>
<object name="T_BASIS_USER" datalastupdateddate="2022-06-10T02:01:00" datarecordstatus="P">
<property name="USER_ID" datavalue="rushikesh.vartak"/>
<property name="USER_GROUP" datavalue="DEFAULT"/>
</object>
</data>

 

JSON: after online conversion  https://www.convertjson.com/xml-to-json.htm

{
"data": {
"class": {
"property": [
{
"_name": "USER_ID",
"_datarequired": "true",
"_sortheader": "true",
"_viewlabel": "User Id",
"_datatype": "STRING",
"_key": "true",
"_uniquekey": "false",
"_vieweditable": "false"
},
{
"_name": "USER_GROUP",
"_datarequired": "false",
"_viewhidden": "true",
"_viewlabel": "User Group",
"_datatype": "STRING",
"_key": "false",
"_uniquekey": "false"
}
],
"_name": "T_BASIS_USER"
},
"object": {
"property": [
{
"_name": "USER_ID",
"_datavalue": "rushikesh.vartak"
},
{
"_name": "USER_GROUP",
"_datavalue": "DEFAULT"
}
],
"_name": "T_BASIS_USER",
"_datalastupdateddate": "2022-06-10T02:01:00",
"_datarecordstatus": "P"
},
"_description": "Energy Components",
"_sqlTime": "2220953",
"_inmemory": "true",
"_ecVersion": "13.0.10",
"_systemofmeasurement": "",
"_apiVersion": "v1",
"_daoTime": "13501",
"_presentationcontext": "/rest"
}
}

 

hence listfield will be object & colsToProp will be property._datavalue ?


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

@rushikeshvartak 

Yes try listfield as object & colsToProp as property._datavalue

Regards,
Sagar Srikantaiah

 

@sagars - How REST API will know it has to take input from USER_ID & not from USER_GROUP ?


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

sagars
Saviynt Employee
Saviynt Employee

@rushikeshvartak

The path for both USER_ID and USER_GROUP is exact same so REST Connector consumes both the values.

Regards,
Sagar Srikantaiah

Sharukh_Shaikh
New Contributor III
New Contributor III

Hi Rushikesh,

Please add the AccountID Field in the colsToPropsMap mapping.

Thanks,

Sharukh.

 

rohan32
New Contributor
New Contributor

Hi,

can you please provide a sample if else condition format that we can use in xml in rest connector?