New Features – Common Data Service, SQL and Power BI !!!
One of the cool recent announcements by Microsoft is the ability to write T-SQL queries against a Common Data Service database using SQL Server Management Studio. This also includes the…
Software + Imagination
One of the cool recent announcements by Microsoft is the ability to write T-SQL queries against a Common Data Service database using SQL Server Management Studio. This also includes the…
…data. Let’s use Accounts as an example. We can access the API through the address https://yourorg.api.crm.dynamics.com/api/data/v9.1/: We can then get accounts using https://yourorg.api.crm.dynamics.com/api/data/v9.1/accounts: Now, accounts have a lookup field for…
…as in the App we specified above, e.g. http://contoso.com. authurl: https://login.microsoftonline.com/common/oauth2/authorize?resource={{url}} Click Add: Now, select the environment: Let’s set up some variables for this environment. Go to settings: And Globals:…
…You will then see links to the Web API and the OData Organization Service: Web API URL: https://orgname.api.crm.dynamics.com/api/data/v8.1/ The service URLs: https://orgname.api.crm.dynamics.com/XRMServices/2011/Organization.svc https://orgname.crm.dynamics.com/XRMServices/2011/Organization.svc To get the OData: https://orgname.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/ https://orgname.api.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/ …
…updated or modified”: Let’s change the Salesperson role at the root business unit level: We will change it so Leads are viewable to the Business Unit level only (it previously…
…to learn by video, check out my YouTube channel video on how to do this: https://www.youtube.com/watch?v=A266dC1mYb8 First, log into https://flow.microsoft.com and go to Solutions and create a new solution: Give…
…and publish it to powerbi.com using our Administrator account. If we browse out to the report in powerbi.com as Administrator, we can see our report showing all our opportunities: Now…
…We will provide the following: Method = POST URI = https://login.microsoftonline.com/common/oauth2/token Headers: Content-Type = application/x-www-form-urlencoded Body: Replace the bold below with your information: grant_type=password &username=your@email.com &password=yourpassword &client_id=your client id from…
…the video on this, check out the video on my YouTube channel: https://www.youtube.com/watch?v=1bM2lEspEbQ First, let’s create a new Business Process Flow. We can do this by signing into https://flow.microsoft.com and…
…that we will use to authenticate with the Power BI API. The type will be POST and we will be sending the request to https://login.microsoftonline.com/common/oauth2/token. We will also send the…