I just want to create a replica of my data extension on a web page where my team can see the status of each subscriber. I've tried achieving this from this documentation but it's just pulling only one column.
Agreed with the comment from Johannes Schapdick above: Apply this with extreme caution. This is NOT a performant solution, it will lag or time out with bigger amounts of data. Also, a public page that exposes your PII like emails might not be a good idea either. Logins are there for a reason.
Still, sometimes this approach can help and serve as a starting point.
The following concepts are applied: Build a Retrieve using a filter that applies to all records. This only works if you can filter for a field that all records have in common:
So, build a field like field "include" with a defaultValue of 1 in the DE. This common "hack" enables you to retrieve "all records", with the following limitation:
You have to loop the retrieves as one iteration only gives you 2500 records, which you can circumvent using ContinueRequest / moredataavailable.
I am sure this works with leaner code (WSProxy) as well, but this "old school" code has served me well:
Hope this helps.