I'll do my best to point you in the right direction but a better place to ask this question would probably be in the documentation as this tag targets DevTest Labs related issues:
https://learn.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro
or
https://learn.microsoft.com/en-us/common-data-model/
Similar question recommending Flow:
https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/CDM-API-Access/m-p/20230
Additionally, it appears that there may be open source solutions for what you are trying to accomplish.