Share
ReportI'm configuring eConnectOut for searching GL Accouns by description or by account number.
The account number column is only present in GL00105 and account description in GL00100.
I don't want to deal with 2 different XML result formats for when I query by account number or by account description.
From what I understood if I configure eConnect out to query the 2 tables with a join I can only search by columns in the main table and not the child table.
To query the child table I need to create a second eConnect out content type where the main-child relation is the opposite of the first configuration so that I can query from the second table.
I'm find with creating 2 content types but I don't want to deal with 2 different XML structures. From what I understood the main table has to be the outer tag in the XML result and the child table should be a nested tag.
e.g.
<GL_Accout>
<Details></Details>
</GL_Account>
when I need to search by a GL_Account filed
and
<Details>
<GL_Account></GL_Account>
</Details>
when I need to search by a Details field
Is there a way to keep the same output XML structure but to query by fields from the main or the child table?
*This post is locked for comments
All responses (
Answers (
5,701
