cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndKanPA
Resolver I
Resolver I

Tool to manipulate CDS

Is there a tool like "MySQL workbench" or MSQL Management Studio to access CDS entity data directly?

 

Simple fetch commands of course with Xrm fetchBuilder but updates?

Why I'm looking for:
I import null-date values with a special date '1970/1/1' and want to change this in CDS back to null or ''

 

Thanks,

AndKan

1 ACCEPTED SOLUTION

Accepted Solutions
OliverRodrigues
Super User
Super User

There is a Web API available: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/overview

 


------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 




If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Apps Portals Super User


Oliver Rodrigues


 

View solution in original post

3 REPLIES 3
OliverRodrigues
Super User
Super User

There is a Web API available: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/overview

 


------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 




If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Apps Portals Super User


Oliver Rodrigues


 

As Oliver Mentioned, you can write your simple service call to Web API to achieve this. But I can see in your other post you have achieved it by changing `Locale`. to English United Kingdom. Hope the problem is solved.

You are right, this problem seems to be solved.

But such a tool maybe usefull in other cases too.

 

Thank you both for help,

AndKan.

Helpful resources

Announcements
May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel News & Announcements 768460.png

What's New in the Community?

Check out the latest News & Events in the community!

MPP IDEAS updated 768x460.png

Ideas

Discover ideas and concepts from users like you for how to use Power Pages and take your work to the next level.

Top Solution Authors
Users online (1,444)