Developer forum

Hi Ricardo,
1) It is not implemented. You can try to submit a new feature request for that. You can also try to implement it yourself using the OnAfterErpCommunication Live Integration subscriber

where you can use C# to sort the returned xml in your need order.

2) You can use this subscriber: GetListOnAfterAddInvoice and this code to add your custom fields values:
XMLCurrNode.SelectNodes('//item', xmlNodes);
xmlNodes.Get(xmlNodes.Count, pXmlNode);
XmlHelper.AddField(pXmlNode, 'customFieldName', 'custom field value');

BR, Dmitrij

Hi Dmitriy,

Thank you for the quick response.

About the issue 1:
"OnAfterErpCommunicationArgs.Response" is a string, and I can convert it to XML and sort it, but I can't set the response again (OnAfterErpCommunicationArgs.Response) because it's not writable.
And I can see another problem - The response only gets 10 items, so even if we do the sorting, it will only sort those 10 items, because it's being paged.

Hi Ricardo,
correct, sorry mine suggestion will not work in that case. Maybe we should look of imeplementing a custom subscriber on the BC side using:
OnBeforeExecuteGetListRequest - here you can implement your own response for specific request.
I can send you the currently used source code (to your email) for that so you can add a few lines to sort it on specific field
or
OnAfterExecuteGetListRequest - this where you can use AL to try to sort the generated xml in a proper way.

Then on the live integration side you can subscribe to the Xml generation request and pass the sorting parameter if needed
so it can then be read from the BC subscribers from above.

​BR, Dmitrij

Hi Dmitriy,

If you could send me the source code it would be awesome.
Thanks for quick answers.

Hi Dmitriy,

Will you also send me the source code regarding the sorting issue.

Best regards
Niels Foldager

Hi Dmitrij,

We also need to change the order. Could you please send me the code?

Thanks,
Tomás

Hi Tomas,
I am not sure you need the source code as this feature was already implemented in one of the latest BC releases 1.2.0.21 and 1.2.0.22:
https://doc.dynamicweb.com/downloads/integration#sideNavTitle1-3

The new behavior works like that:
<GetList type="Invoice" customerID="1234" requestAmount="10" firstItem="10" sortByField="" sortDirection="DESC"></GetList>Two new params added to the GetList request:

Hi Dmitrij,

What would be the code if what I need is to replace the data of a column?

Should I subscribe to the same event GetListOnAfterAddInvoice?

Hi John,
yes, that is the correct event.
Then you can use the codeunit 6211191 DynamicwebXmlHelper
and try to call this method to update the value:
DynamicwebXmlHelper.AddOrUpdateFieldValue(xmlNode, 'YourColumnName', 'YourValue');
BR, Dmitrij