Trying to format Dynamics “Lookup” fields into OpenAsset but the data is coming in as the GUID and not the Text in the field.
CSV won’t work because it’s 1) too big (370k vs 150k) and 2) is hosted on Sharepoint (not publicly accessible)
Manual Format won’t work because there are 1000s of entries that are constantly changing.
Any advice?