The StringMap table from Dataverse is not available via MS Dynamics 365

We are utilising Dataverse to extract data from MS Dynamics365, but the StringMap table isn't available from DBO schema. We required this to match the option-sets.

The documentation referred for setting this up: Link

Have connected to the tables via MS SQL server, dataverse and couldn't find the StringMaps table.

Upvotes: 0

Views: 900

Answers (2)

Federico Jousset
Federico Jousset

Reputation: 1761

Have you checked the choicelabels table?

select *
from dbo.choicelabels

Upvotes: 3

Malachy
Malachy

Reputation: 392

I believe the underlying table name is: StatusMapBase

The view FilteredStringMap should be there as well as a view call dbo.StringMap

Upvotes: 0

Related Questions