I have come multiple times across the situation where when using HTTP get request I get back data with column names containing dollar sign ($). For exmaple JSON such as:
{“Payments”:[{“PDocumentType”:“”,“LocalAmount”:18000,“DocDate”:“2024-02-01T23:00:00.000Z”,“DocumentType”:“01”,“Period_ID”:“1SG0000101”,“DocQueue_ID”:“2R30000101”,“Profit”:“X”,“BankAccount_ID”:“0000000000”,“Amount”:18000,“ID”:“32H7100101”,“Currency_ID”:“0000CZK000”,“CashDesk_ID”:“0000000000”,“PDocument_ID”:“0000000000”},{“PDocumentType”:“”,“LocalAmount”:10800,“DocDate”:“2024-02-01T23:00:00.000Z”,“DocumentType”:“01”,“Period_ID”:“1SG0000101”,“DocQueue_ID”:“2R30000101”,“Profit”:“X”,“BankAccount_ID”:“0000000000”,“Amount”:10800,“ID”:“42H7100101”,“Currency_ID”:“0000CZK000”,“CashDesk_ID”:“0000000000”,“PDocument_ID”:“0000000000”}]}
Such as result cannot be saved in a XML context, because dollar sign is not a valid character.
I would be great to have the possibility to ommit or replace or somhow transform such as result before merging into the XML context.