Transcript:
0:04 in this video we're going to show you
0:06 how you can use the North52 business
0:08 rules engine for Microsoft Dynamic 365
0:11 and the Azure Maps API to set the
0:13 latitude and longitude based on the
0:15 address details of a lead if we update
0:18 the address details of this lead record
0:20 we can see that the latitude and
0:22 longitude values are
0:25 updated we will now look at the formula
0:28 which enables this to happen formula
0:30 type is save perform action and Triggers
0:32 on the street one City ZIP postal code
0:36 and Country region Columns of the lead
0:39 entity we have set up four conditions to
0:42 check that these columns contain Data
0:44 before sending this information to the
0:46 isual maps
0:48 API in column e we have an inline
0:51 calculation that combines the address
0:52 columns into a comma separated string
0:55 which is used for the query parameter of
0:57 the aure maps API request column F
1:00 builds up the URL to be used in the API
1:03 request setting the subscription key
1:05 using an xcash record and the address
1:07 from the previous inline
1:09 calculation let's quickly take a look at
1:11 the xcash record the base key is set to
1:14 Azure Maps uncore primary subscription
1:17 key and the data type set to string
1:20 password and the value of the key
1:22 obtained from theur map
1:25 settings now back to the formula column
1:28 G is where we connect to the Azure Maps
1:31 API using the North52 call rest API
1:34 function we set the set request Bas URL
1:37 to the final URL variable from column F
1:40 set request details is set to get and
1:44 set requested expected to
1:47 okay within the set request action pass
1:50 parameter we are using the smart flow
1:52 function to allow setting two variables
1:55 the latitude and longitude
1:57 values finally in column H and I we use
2:00 the extracted values to set the columns
2:02 address one latitude and address one
2:05 longitude on the lead
2:07 record if you'd like to know more please
2:09 review the associated article on our
2:11 support portal and get in touch to see
2:13 how we can help you with your complex
2:15 business rules requirements from the
2:16 Dynamics platform also please don't
2:19 forget to subscribe to our YouTube
2:20 channel