Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to get all table n...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to get all table names specific to a solution/current solution

(0) ShareShare
ReportReport
Posted on by Atmaram90 5

Hi,

I am trying to retrieve entity metadata (all entities) that are part of a specific solution.

Right now I am able to get all tables using webapi ([Organization URI]/api/data/v9.0/EntityDefinitions) whihc is returning all the tables of the environment/organization.

reference link: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/use-web-api-metadata

Can anyone please help me to find the way by which only the tables that are part of a solution can be retrieved?

Appreciate your help.

Thank you.

  • Atmaram90 Profile Picture
    Atmaram90 5 on at
    RE: How to get all table names specific to a solution/current solution

    Finally I am able to get the entity IDs based on solution id

    /api/data/v9.0/solutions({solution id})/solution_solutioncomponent?$filter=componenttype eq 1

  • Atmaram90 Profile Picture
    Atmaram90 5 on at
    RE: How to get all table names specific to a solution/current solution

    Hi Mahen,

    Thanks for the reply.

    I have tried with solutioncomponent but there is no related entity to traverse.

    Also tried another approach by invoking /api/data/v9.0/entities .But this API returns a solutionId which is different from my solution's id as a result I can't filter.

    Still trying and finding on the hope of getting a solution.

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: How to get all table names specific to a solution/current solution

    Hi,

    Did you try to use solutioncomponent and related entity ?

    docs.microsoft.com/.../solutioncomponent

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans