Forum Discussion
Tracking changes in content feed by excel
Good day folks,
Herewith an issue we have been struggling with for a while. We have checked with microsoft support for several attempts but unfortunately without success.
For context, we have multiple content feeds from vendors. These feeds contain individually unique data, e.g. there is a feed with product numbers, stocks etcetera. In order to make these feeds practical for ourselves, we want the feeds to show all changes when refreshing. So that we can implement these changes in our own system. How can we best accomplish this?
Anyone with suggestions or the solution?
- Alle the feeds are in a XML format, we import these into excel as a query.
If that's Power Query perhaps you may query both already returned feed from the sheet, new feed, merge them and generate changes. However, not sure.
What exactly the feeds are, is that OData or something else?
- there is a feed with product numbers, stocks etcetera. In order to make these feeds practical for ourselves,
online form?
e.g.
ms form to collect info?
