
Announcements
Hi All,
I was trying to figure out how to change a virtual table source from a dev copy of a list to a prod copy and I couldn't find any documentation on this.
Took some time of figuring out but finally did....thought I'd share this.
Please advise if this is not the right place.
Essentially once you've imported your VT to your target ENV and need to repoint or even refresh the connection (connection could break):
1. Go to Advance Settings -> Administration -> Virtual Entity Data Source
Here verify that the data source that your VT is using is pointed to the correct one (SP Site in this case). You can either update the value or create a new record (I had to create a new one because my import failed somewhere and corrupted the record).
2. Advance Settings -> Customizations -> Customize the System -> Entities -> Look for your VT.
Here, if you created a new DS (step 1), you will need to change the data source drop-down to the new record you created in step 1. (if refreshing, this should do the trick)
Next, change the External Name value to the correct ID of SP List,
Do the same thing for External Collection Name but keep the "s" at the end.
Save and publish.
Revisit your VT and should not be showing you data to wherever you repointed it.
@JanGenese09