How to update the Business Partner Contact Persons using B1IF?

[former_member416544]

Hi Experts,

I want to update the Contact Persons(OCPR) details in Business Partner(OPMG) using B1 Integration Framework scenario(Here I'm using B1 Batch Atom to update the multiple records).

While I'm trying to updating the Contact Person details using B1IF, it's thrown an error message

Here is my input example file bp-contactperson .xml

Can you please someone suggest me to update the contact person details using B1IF.

Thanks,

Chenna

[krishnkumar_be]

Hi Chenna,

Use this payload structure to B1 Object atom, it will update/add contact persons to BP code mentioned.

        <QueryParams>
        <CardCode>Test_Contact</CardCode>
        </QueryParams>


        <BusinessPartners>
            <row>
                <CardCode>Test_Contact</CardCode>               
            </row>
        </BusinessPartners>


        <ContactEmployees>
            <row>
                <Name>1111</Name>
                <Position>1111</Position>
                <Address>Test</Address>
                <Phone1>123456789</Phone1> 
                <E_Mail>string@gmail.com</E_Mail>
                <Remarks1>string</Remarks1>
                <Remarks2>string</Remarks2>               
            </row>
             <row>
                <Name>1112</Name>
                <Position>1111</Position>
                <Address>India</Address>
                <Phone1>9876543210</Phone1>                               
                <E_Mail>string@gmail.com</E_Mail>
                <Remarks1>Test add Contact Person</Remarks1>                             
            </row>
        </ContactEmployees>

[HuanYang]

Hello Chenna,

We test OK with the code you provided in latest version both 1.x and 2.0.

Thanks & best regards

Huan Yang

[former_member416544]

Hi Yang,

Could you please have a look at the above my error message, in some cases Contact person updated, in some cases it's throws above message. I'm unable to update the contact person more then 1 details.

Can you please suggest the solution.

Many Thanks,

Chenna.

[HuanYang]

Hello Chenna,

The message is from DI, which is a standard message.

To update the child object is something we must take much care, especially there are multi lines.

From Integration perspective, you may use call B1 object call or B1 service layer atom to do the separate one if it's unstable as you mentioned.

A separate atom may be easy to handle.

Thanks & best regards

Huan Yang

[HuanYang]

For the usage of update child table in a call B1 object atom, you may refer to the answer of another question

B1if: How to update Child Tables

[former_member416544]

Hi Yang,

Can you please suggest me.

Can I use sqlCall atom to update the any details in SAP B1?

Like: In my scenario step, atom1 I have created sql tag <sql>Update OCPR SET FirstName='ABC', LastName='DEF' where Name='XYZ'<sql>

Now, I will create sqlCall atom to update the details into SAP B1.(In this way, I can achieve to update multiple details in SAP B1)

Thanks,

Chenna.

[HuanYang]

Hello Chenna,

I do not suggest you do like this.

If you do directly execute SQL statement in Database level, SAP may do not support.

Thanks & best regards

Huan Yang

[HuanYang]

Hello Chenna,

May I know which B1if version do you use?

We test OK with the code you provided in latest version.

thanks & best regards

Huan Yang

[former_member416544]

Hi Huan Yang,

Thanks for your prompt replay,

I'm using B1IF

Version 2.16.1 version.

Thanks & Regards,

Chenna.