Example of Message body for API_DoQuery Webhook
Can someone provide an example "Message Body" for an API_DoQuery Webhook, I'm lost on how the fields get populated from the XML reply and I'd like to see the structure of the code.
Forum Discussion
I have this so far
<qdbapi>
<usertoken>%user.token.XXXXXXX_XXXX_cgmx.Weebhook 001%</usertoken>
<apptoken>XXXXXXXXXXXXXXXXXXXXX</apptoken>
<field fid="85"><query>{17.EX.'BEL001@bombouche.com'}</query></field>
<clist>108</clist>
<includeRids>1</includeRids>
<options>num-1.sortorder-A</options>
</qdbapi>
This is trying to bring in the company name based on the email address. Fid 108 is the company name field. 17 is the email address field.
I'm not sure if this is the correct layout as there seems to be little information out there and the example from the api guide looks off.
It would be great to see a working example.
<qdbapi>
<usertoken>%user.token.XXXXXXX_XXXX_cgmx.Weebhook 001%</usertoken>
<apptoken>XXXXXXXXXXXXXXXXXXXXX</apptoken>
<field fid="85"><query>{17.EX.'BEL001@bombouche.com'}</query></field>
<clist>108</clist>
<includeRids>1</includeRids>
<options>num-1.sortorder-A</options>
</qdbapi>
This is trying to bring in the company name based on the email address. Fid 108 is the company name field. 17 is the email address field.
I'm not sure if this is the correct layout as there seems to be little information out there and the example from the api guide looks off.
It would be great to see a working example.