Note on the <fields> tag
Many calls allow use of a <fields> tag to specify what information is returned. The log can be used to see the actual SQL statement passed to the database in order to see what fields are passed by default and what aliases are used (e.g., i for items, it for itemtree). This is for advanced users only and this field must be used carefully. Here’s an example of how the <fields> tag is used:
<func>lookupguests</func><first_name>matt</first_name><fields>g.guest_no, g.first_name, a.address</fields>
Example:
When using the getitemtree call with the <calcprice> tag set, if you specify the <fields> tag and do not include pricing fields, the prices are all calculated to be zero. Most of these problems come from the “composite” calculations such as the <max4sale> tag and the <calcprice> tag.