…To select top, we can use: https://yourorg.crm.dynamics.com/api/data/v9.0/contacts?$select=firstname,lastname,address1_city,birthdate&$top=10 Filter To filter, we can use: https://yourorg.crm.dynamics.com/api/data/v9.0/contacts?$select=firstname,lastname,address1_city,birthdate&$top=10&$filter=firstname eq ‘Jim’ This then translates to: https://yourorg.crm.dynamics.com/api/data/v9.0/contacts?$select=firstname,lastname,address1_city,birthdate&$top=10&$filter=firstname%20eq%20%27Jim%27 To filter on birthdate, use (note no quotes): https://yourorg.crm.dynamics.com/api/data/v9.0/contacts?$select=fullname,birthdate&$top=100&$filter=birthdate…
…can do this with the query. Again, we divide each operator with the & symbol. This produces: https://crm374549.api.crm.dynamics.com/api/data/v9.1/accounts?$select=name,telephone1,revenue,industrycode,_transactioncurrencyid_value&$top=10&$orderby=name%20asc&$filter=revenue%20gt%2010000000 TIP: A list of operators additional can be found at https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/query-data-web-api …
…Operations and Dynamics GP. Hope you learn something, and of course, feel free to connect with me: Twitter – https://twitter.com/carldesouza LinkedIn – https://www.linkedin.com/in/carld/ YouTube – https://www.youtube.com/user/carldesouza Email – carl@carldesouza.com …
…learning and solving problems. Hope you learn something, and of course, feel free to connect with me: Twitter – https://twitter.com/carldesouza LinkedIn – https://www.linkedin.com/in/carld/ YouTube – https://www.youtube.com/user/carldesouza Email – carl@carldesouza.com …
…useful if you’re waiting for new features to come out, for example the T-SQL access to the Common Data Service. We can also use this to connect to any of…
…to publish Excel image snapshots to Power BI. To install it, go to https://www.microsoft.com/en-us/download/details.aspx?id=50729 Note the supported versions of excel: Excel 2007, Excel 2010, Excel 2013, Excel 2016 Select the…
…YouTube channel: https://www.youtube.com/watch?v=2ySv6sBfbqQ&feature=youtu.be Go to https://flow.microsoft.com and select to create a new Business Process Flow: Let’s call it Account BPF: We see: Let’s make 3 stages – Stage 1, Stage…
…Customer00001 = new Customer(“Bob”, “Smith”, “bsmith@test.com“, “555-111-2222”); var Customer00002 = new Customer(“James”, “Johnson”, “jjohnson@test.com“, “555-111-3333”); // Print out the first name of the Customer00001 alert(Customer00001.firstname); This returns “Bob”. If we…
…and the subscription: Pricing calculator: https://azure.microsoft.com/en-us/pricing/calculator/ Estimated costs (link not working but previous link: https://github.com/Microsoft/BusinessPlatformApps/tree/master/Source/Apps/Microsoft/Released/Microsoft-CRMSalesManagement#dynamics-365-export-pricing) Connect to Azure Key Vault: Click Next: Connect to SQL. Either select an existing database…
…will use this later: And a report with the URL https://app.powerbi.com/groups/ade7c4e4-1bdd-4472-8aa5-744febb1c8e6/reports/f979c710-1977-4598-9db2-74b5c801290c/ReportSection: Power Apps Portals Setup Go to the PowerApps Portals admin center by logging into https://make.powerapps.com/ and selecting your Portal…