I recently tested / used the dw.ExportJson() combined with JSONPackage and I am starting to feel that it's time to move on, from restful XML services to JSON.
What worries me is that I didn't find any way to limit the data exported ExportJson(). Some datawindows contain many columns that I don't want to export, because I want to have smaller payloads and also because I don't want to expose sensitive data.
This is very easy when exporting XML because the datawindow can contain multiple export profiles, and each of them can contain only the columns needed for the specific task.
Using JsonPackage to delete each undesired key, sounds like a nightmare and I feel that I will loose the benefit of speed.
Am I missing something or do you have any workaround for this problem?