REST Connector ImportAccountEntJson with text/xml format input

[rushikeshvartak]

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

Any additional configurations needs to be done ?

[sagars]

@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"

Regards,
Sagar Srikantaiah

[rushikeshvartak]

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 ?

[sagars]

@rushikeshvartak 

Yes try listfield as object & colsToProp as property._datavalue

Regards,
Sagar Srikantaiah

[rushikeshvartak]

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

[sagars]

@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 · Accepted solution]

Hi Rushikesh,

Please add the AccountID Field in the colsToPropsMap mapping.

Thanks,

Sharukh.

[JayashreeL]

Note added in ImportAccountEntJSON and ImportUserJSON parameters table

https://saviynt.freshdesk.com/support/solutions/articles/43000521736-rest-connector-guide#RESTConnec...

https://saviynt.freshdesk.com/support/solutions/articles/43000521736-rest-connector-guide#RESTConnec...

[rohan32]

Hi,

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