XML integration

[AtrayeeDutta07]

Hi Team,

We are doing NetSuite OpenAir integration using XML API, 

Below is the Request :

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<request API_version="1.0" client="ULSB2" client_ver="1.1" namespace="default" key="i6SlzfCtaiWgXIRt9xu3">

    <Auth>

        <Login>

            <company>***</company>

            <user>****</user>

            <password>****</password>

        </Login>

    </Auth>

    <!-- XML API commands -->

    <Read type="User" method="all" attr_name1="name" limit="1000">

    <_Return>

   <name/><id/><nickname/><role_id/><externalid/><primary_filter_set/><active/><addr/>

            <departmentid/><filterset_ids/><job_codeid/>

    </_Return>

    </Read>

</request>

Response with 1 user(response file attached):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<response>

    <Auth status = "0"></Auth >

    <Read status = "0">

        <User>

            <departmentid/>

            <name>Frazier, Scott</name>

            <job_codeid>21</job_codeid>

            <role_id>48</role_id>

            <id>4</id>

            <filterset_ids/>

            <active/>

            <externalid>34287</externalid>

            <primary_filter_set>11</primary_filter_set>

            <nickname>scott.frazier@ul.com</nickname>

            <addr>

                <Address>

                    <salutation/>

                    <mobile/>

                    <state/>

                    <email>scott.frazier@ul.com</email>

                    <addr2/>

                    <city/>

                    <fax/>

                    <contact_id/>

                    <addr1/>

                    <id>-1</id>

                    <middle/>

                    <country/>

                    <first>Scott</first>

                    <last>Frazier</last>

                    <phone/>

                    <addr4/>

                    <zip/>

                    <addr3/>

                </Address>

            </addr>

        </User>

    </Read >

</response>

Connection JSON:

{
"authentications": {
"login": {
"authType": "basic",
"properties": {
"SOAP_ENDPOINT": "****",
"USERNAME": "*****",
"PASSWORD": "*****",
"company":"****",
"PASSWORD_TYPE": "PasswordText",
"REQUESTPARAMS": {
"CONTENT-TYPE": "text/xml;charset=UTF-8",
"Connection": "Keep-Alive",
"Keep-Alive": "timeout=600, max=1000"
}
}
},
"accessProvisioning": {
"authType": "basic",
"properties": {
"SOAP_ENDPOINT": "*******",
"USERNAME": "**",
"PASSWORD": "***",
"company":"****",
"PASSWORD_TYPE": "PasswordText",
"REQUESTPARAMS": {
"CONTENT-TYPE": "text/xml;charset=UTF-8",
"Connection": "Keep-Alive",
"Keep-Alive": "timeout=600, max=1000"
}
}
}
}
}

AccountImportJSON:

{
"CONNECTION":"login",
"REQUESTXML":"<request API_version="1.0" client="ULSB2" client_ver="1.1" namespace="default" key="i6SlzfCtaiWgXIRt9xu3"><Read type="User" method="all" attr_name1="name" limit="1000"><_Return><name/><id/><nickname/></_Return></Read></request>",
"RESPONSEDATAPATH": "response.Read.children()",
"ACCOUNTMAPPING": "NAME:User.nickname,ACCOUNTID:User.id"
}

Getting error  in import, Can anyone please share any sample import JSON?

Regards,

Atrayee

[Dhruv_S]

Please confirm which connector you are using and which documentation you are referring for this integration.

[AtrayeeDutta07]

OOTB SOAP connector