so um so we’re gonna get started here right on time we promise we’ll finish on time and so yeah so we’re going to talk today about how to connect to any API right without writing any code so you’re not going to Macias write any code because we’d be violating the first derivative of this webinar as well so so my name is dawn murray and i’m one of the founders of safe you know get still get excited about technology in particular get excited about cloud server parallel processing elasticity darker all these sorts of great things yeah and I’m sitting here with Stewart so tell you later it’s all Stewart yes so I’ve been here nine to eight years now Wow eight years I work on the cloud team so those of you know called our enterprise running on Amazon and also open barely anything to do with cloud technologies or API so the website I still remember the day you started or the day you so many walks in my office said there’s this guy named Stuart Harper at the front and he wants a job Wow that’s it where’s he from he’s from England I’m like oh my goodness met you in that so yeah so that’s who that’s who we are as in Stuart and Dawn so it’s safe fun for those who don’t know what safe does all about moving data for mantra sort of is you know data has a natural place where it wants to be it could be in the database and aren’t that our whole thing is for getting data from wherever it is to where you want it to be it’s on and so we’ve done for years we’ve you know really we’ve really nailed the if we talk about bowling alley analogy we’ve really nailed the spatial ones we’re really the V spatial moving and it doesn’t matter what kind of spatial 3d like data align our data if it’s spatial we move it yeah and and so now you know as with web so one of the things that is exciting is of course there’s services that are spatial as well yeah so by that’s safe we do all kinds of things we’re not strictly we’re not strictly spatial people might think of spatial but really any kind of data you want to move right we do it and in this webinar we’re going to talk about Web API yep and that really to us is just to connect these things together really what are you moving just dicing yeah and the fully enough spatial data is probably the most complex yeah yeah so we’re good at that yeah the standard Jason targets raw JSON and XML so just watch a two-minute video we’re not gonna watch it online but go to WWE and click that play button and there’s a great two minute video if you have no idea what we do and you’ll learn all about it right there so so that’s worth your while so what is an application and programmatic programming interface well you know this kind of there’s a technical definition of it yeah which is talk about the resources and they could get in the post and they you know that but I think the key thing for an API is what it allows a company to do is expose the core business logic in a stable and secure way so this is really crucial because you know all the tools and services of these cloud companies and all these different vendors provide it allows them to to serve these up to developers or just their general customers in a stable and secure way yeah so you can interact with you know whatever business logic they’re exposing through this one interface and know what to expect and that’s key yeah and I think the other thing is is cloud companies have almost had api’s but now it’s so competitive out there it’s not whether your API is there it’s how good it is right so so really everything must have an API no we would not internally it safe we would not consider a product without an API in cloud products you need to get your data in to get your data out yeah and you need to synchronize so even you know when I buy commercial products like I bought a wink hub for my house so I can control my lights talk to my alarms I did some research and the reason that when the reason is about wink is it two had an API okay so now with that for me I my alarm company send me an email every time that my alarm is either armed or disarmed and I can turn on my cameras on and off because I don’t really want my cameras on when I’m in the house it’s kind of that’s kind of creepy so I’m so I’m so yeah so so really you know the API is everything and like Stuart said that’s safe we don’t get anything we don’t we’re moving you know if you look at where we were moving to we’re moving to have really focused apps one has an API because now the challenge is you got to connect them so that you get more value exactly yeah yeah and it used to be a website used to be a phone

as an entry point to a business and now it’s an API so why are they becoming so popular the first thing is is was just seen a massive shift of both infrastructure and data to the cloud and obviously data comes with infrastructure shift into the cloud yeah we’ve got Amazon we’ve got a zero we’ve got Rackspace we’ve got all these vendors allowing all this infrastructure to shift to the cloud we’re seeing more and more data like where do you get your data from massive oh yeah yeah all these other vendors it might be honest three mark on Dropbox might drive yeah any applications we get again Zendesk Twilio right you know live chats open all these things again Salesforce yes they all have API so and so yeah they’re becoming easier to build come see so we’ll talk about the split mind that the next slide but you used to have to code yeah I used to have to know what you were doing used to have to develop infrastructure now yeah you can build an API in half a day yeah that’s that’s crucial yeah yeah and consume them is trivial like this thing I talked about I mean I barely know what I’m doing honestly unable to get it working so anyway so yeah you kind of just talking about this the rise of mobile and IOT as well certainly mobile the API kind of micro services infrastructure really lends itself well to mobile yeah so we’ve seen an explosion in kind of mobile based applications that backup basic app developers yeah yeah in this API first strategy so I know it’s on cloud you guys have always had an API first strategy yes yeah every product we build must have an API yeah and before we write code we’d go out and almost look for a service before we write the code yeah because we really only want to write code there’s business logic that’s time to save cyber yes actually yeah we don’t want to be writing credit card code or you know so yeah that’s yeah and you know like on the server as well you know that each iteration of the web interface is smaller and smaller and smaller because now they to have that API first strategy before they do anything right the API and once the API is there then build the web interface or whatever all right yeah and there’s a famous letter from from bezels that was sent to all the staff at Amazon yes which basically said I’m paraphrasing obviously they said hey we’re adopting an API through strategy you either adopt this strategy or you know there’s no room here for you yeah I mean this company’s Amazon Twitter eBay Salesforce they wouldn’t be the company’s there today they didn’t come out with this API share strategy yeah and now other companies are copying across many sectors and they’re all disrupting as well yeah so this agility that API is bring you know the modern enterprise demands it yeah you need to be able to fail fast you need to be able to try throw things away and move very quickly and that’s what api’s give you okay good so with this slide about so this is what comprises an API I just wanted to kind of give you an overview this probably going to be more of a focus in the next webinar but there’s three components that I see comprising API and that’s the management of security the interface itself so the resources the methods and then the business logic that’s tied to each resource it’s going to go get the data from the service on a database and and presented to the end-user yeah so on the left is where we we were originally two years ago the self hosted API build it all yourself hold it all manage it all host it do everything you needed to know what you do yeah new to developers the next is where we’ve kind of shifted to this managed API so the security the API management the scaling the rate limit in the authentication yeah that’s all handled through a third-party provider yeah but the business logic and the interface you still need you still have to define yeah so rails no play whatever the HP yeah and now on the right is where we’re staying to move to and that you can create now with this model on the right I call them disposable api’s project-based API is that last days and so the authentication the authorizations pulled out into a service you know management’s still wearing the service the restful interface you can define in a GUI yeah click-click-click so if I guess I go left from right it you can think of it as a progression of time yeah but also as I go left to right the amount of effort that is required is much much less yeah and we’re gonna show you to this webinar is about what you can do with that for me we’re gonna get at the very highest level show you how you can connect these things together using FME but then we’re not going to tell you how to actually build that that’s the next leg yeah and the crucial thing on the right is the business logic

yeah so you used to have to write code but now you can hook a for me into API gateway yeah so you can basically write no code to extract data from a database or service no this is exciting yeah so why should people care I think you already said it I mean the future belongs to razor focused these small application we even look at what we did it safe yeah you know we adopted Salesforce we like Salesforce is a great CRM but initially we we also we also use it for support and a bunch of other things and it did a fine job but we found much more razor focused applications for support much more razor focused applications for the community right and only haven’t done the support log in the live chat so now you know we’re still using Salesforce but now we have our community on a new a new tool yeah and answer hub and it’s just fantastic we’re connecting them with API so to our users they just see this you know the experience is just you know enriched right but from our standpoint we get more information but we’re not copping all the data out in that case we’re leaving the data where it is and this is in the data back and forth that’s that’s necessary but now our Dicer is meant across more so yes the challenge as in that’s why we got it that’s exactly where we’re going to connect these things in your show yeah so one of the challenges for connecting to api’s and working with AP is and this isn’t just a trend without all the charge of coding or doing whatever other ways to connect so the first thing is it you know there’s many different implementations of how you build an API so rest is kind of King it’s sort of like parlays it is it’s not really a spec isn’t no its base rest is a implant is a guidance and an architectural style so like pirates parlay right now and then everyone’s implemented it differently yeah so do you put the query parameters in the header on a string to use a token on you know there’s all these different interpretations which makes it really really complicated when you’re develop and then the soap is well they’re still so same API is floating around so it’s it’s hard to work with these and jump between all these different API a constant evolution so how long did an Oracle database version hang around yeah I mean I mean basically if you had it on site you could have that Oracle version as long as you need it you inside it when things changed and there was years yeah it’s even more still work with them it could be decades that’s right they’re still running in or is it the thing works they don’t want to change it right now so thank you guys you don’t have that luxury yeah Web Services they’re gonna roll forward new api’s the probably version yeah that they might put them on watch but they’re never gonna go away right like you’re not gonna have a web service out there that’s just going to disappear so that could happen – right it’s not normal but it has causes a big headache yeah so you have to be aware of this and the other thing is is error handling so again connecting to a database a local connection you’re over a socket it’s stable it’s blast able – yes they might api’s you’ve got the network to deal with you’ve got the fact that patching a live staff yeah there’s always issues yeah I mean even Amazon they go down sure so you have to deal with that deal you know deal with our situation you’re going over HTTP so yeah so the other big challenge is authentication right so this is a real problem again we’ve got this many standards so our two basic token oh yeah yeah I want to is the main its most popular now in the modern API yeah and again it’s a guidelines it’s not only yeah it’s a guideline that’s got so convoluted and complicated the guy that originally founded the guideline left okay so even he’s not happy with it but we’re stuck with it yeah again the phase out component one my Twitter another Foursquare it’s yeah so no challenge so as we added support for that and safe we you know we initially their initial implementation oops then we hit Facebook okay slightly differently I had the capability also handle that flavor yeah then you get a bunch more than oops you hit another flavor okay and over time you know where we think now we have them all but but we’re never 100% sure that there’s not another flavor of OAuth but right when somebody hits it let us know and we will make sure we deal with that it’s a lotta tube flavor you know this full team thousand public API is I Fortuna so we can’t know exactly and they’re changing like you say exactly yeah so that they’re the general challenges so let’s look at the data integration challenges now so obviously we’re

talking about data integration and connecting yeah there’s two main challenges here the first is this both migration sure so this let’s go back to our sales for example genre yeah so you’re in Salesforce and you want to migrate to Zendesk app for customer support yeah so how did you go about doing that you need to load all your customers across yeah you need to probably load on all of the old cases across yeah there’s a whole bunch of things you have to load across yeah and they have course each system has a completely different data model and so moving it across through put some of the things there you’re gonna have to do a lot of attribute manipulation you’re gonna have some of summons is simple just renaming the attribute but some of them you’re gonna have to split them maybe they one system had first name last name the only just has name yeah you know and then you get into you’re gonna find some fields if that are required in your target system just weren’t in your career earlier system right and vice versa not all the data is gonna match and then you have the issue of duplicate some systems you know the duplicates can exist but maybe in your target system now that’s a key yeah and so yeah we get all these sorts of things and that’s just that’s just where safes lived for years is this whole challenge of how do you move data and the other thing is the data might not it might all just be in Salesforce yes you might need to connect an Oracle database you might need to connect sure I don’t know is open live chat or some metadata outbreak and so you’ve got to be able to merge and join and basically reshape the schema it’s not easy it’s trickier it’s tricky to do in code as well so that’s the first charms that’s the one time or you know you could it could be repeatable process but it’s a big kind of leap you have to take when you’re moving and with that I mean again no code no code yeah you have to understand the data models of course yes okay so the next the next thing is you what you’re up there now yeah you’re using the new services but just say I think some people to join up to all of these new services and you can see the ones we use on cloud here and they kind of forget that they generate enormous data up there you should be aware you’re generating data and you should be wanting to get up update source and then sync it and analyze it and look at it because there’s a lot of information spread out so yeah I mean it’s it we’re using what 20 of your services yeah any cloud but there’s definitely challenges we do an application integration yeah I mean when it comes to data the only time you’re getting value out of data is when you’re when it’s moving exactly yeah so there’s a few key things when you’re integrating services often you want to do this on a schedule yeah daily monthly weakly Alan orally yeah you want to sync system so you need a tool looking you can reliably schedule to do that job and you need that all to give you you know notifications if something goes wrong you don’t just want to set it and forget it we just hope it works event drums yeah because some systems will allow you to put a web hook in when something happens so slack for example you can you put a web hook into the channel yeah and then when something’s posted there you can get a notification so you don’t have to pull or schedule yeah yeah so that’s kind of this assumption wrapping a few more enterprise features around this integration workflow and we’ll we’ll look at some case studies around this a bit later so now let’s see kind of from a high level however for me help solve these problems okay so the first thing and the readers and transformers right so yeah so with FME we have many different readers and writers and many of those are cloud-based so here’s one dynamodb there’s another we call transformer enables you to read and write to Dropbox there’s Salesforce reader and the list just goes on and on and on we basically pick the most popular web services and safe has added support your product so you can see these are the ones that we added for 2016 or overhauled yeah yeah all the big guys that are yeah and these allow you to add a connection point into a workflow and all you need to do is just enter user name password or add a token and then that’s basically you can connect and start pulling data today yeah and for these ones the user wouldn’t even have to know what that’s rest is being used we re leveraged the REST API inside of those exactly yeah it’s all hidden so that’s the first nice thing yeah if you’re getting the big big popular web services this is where you start yeah so the next level down is we have this transformer called an HTTP caller so this is my favorite transformer this is

the one that opens the doors the 14,000 api’s this is the garden I just so yeah back to them yeah yeah do you need to understand a little bit more don’t you about homework yeah you and this one you’re gonna have to open the rest API doc yeah yeah yeah but again we do have a strategy for so only one person in the community has to figure this out so exactly yeah and it’s it’s still no coding you don’t like Python no I’ll show you in a second what this looks like but this is really good for both migration and and system integration yeah and crucially the most complicated part isn’t just entering the URL to the end point it’s off the munication exactly so this is in turn you in the product this year yeah 2016 dot one and you see we’ve got an HTTP caller there and we’re connecting to the Instagram API okay and again we don’t have Instagram out of the box no no this is just showing you how easy it is so we’re going to add in a web connection the called announcer my username and password for Instagram I login within the product yeah it goes out to Instagram gets a token yeah and now I can connect and pulled a to down from Instagram yeah so it’s that easy yeah and that’s really what this is no code here you just need to know the URL and tell me two or three minutes to dance great and we have this kind of support for OAuth 2 token unbasic yeah and you can obviously upload it to our enterprise products as well yeah so definitely server in FME cloud yeah so that’s the authentication and this looks trivial but this was like it’s a huge real amount of effort it’s a lot of code absolutely it’s it’s impressive and it’s complicated and it’s it’s and we took sprite pain from our users so the next level is yeah so so what we want to do here is this 14,000 API is out back yeah summer market specific in different verticals summer country location specific Germany specific we can’t do all of them yeah well there’s also api so we bad bad but like you said her project-based right there’s no way we’re ever going to do a project based API because we’re there’s no where we’re going to know about it exactly yeah so if you go to the hub hub dot save time each other out for you you could start searching for transformer so you know there’s one called Twilio in know that someone’s contributed and that allows you to send SMS messages and it uses the API underneath but actually it’s just a nice transformer that you drop down on the canvas yeah so we’re going to be seeing a lot more of these being added you can see a few in here but I think this is the model absolutely and then we’re going to build the framework we’ll do some of them and then the community can create these and check them in and out update them maintain them yeah it’s exciting and I think this helps for the constant evolution yeah because the community can fix yeah there was a new API rolls out yeah so that that’s crucial and this is where I for me I feel is extremely powerful yeah and that’s on the data transformation side yeah so there’s a lot of tools if you go out then Google’s sales foresters and ask ourselves Frost or wherever there’s point-to-point tools allow you to do a translation and move data but they don’t allow you to do any smart they just try to connect and sling the data across you need to be able to get at the data you need to be able to clean it you need to validate you need to join yeah and these are where all the circle transforms are just amazing yeah could you go back to the hub just one quick disclosure because because you hit an important point here and I just want to make sure people realize that the hub is going to have just go back to the home page the hub is going to have two things ultimately it’s not just it’s going to have the web connections because sometimes those require somebody to dig in deep and figure on the network but it’s also going to have the Transformers well ultimately our goal is is that let’s say you’re working with wait alright somebody does something with wait does the thing it has an API ultimately we want to be to the point where that somebody in the community puts the entire Wenck solution up there like the Transformers and the connection right so then the next person using link doesn’t even have to know the API they just download the thing so and that’s and that’s so the hub I’m just really pretty right now but so what we’re doing it’s just going to greatly reduce the level of effort for all our users very exciting it’s a good point yeah thank you so these I think Robins good shot but how many Transformers have you got now it’s hard there’s a hot ones and you can do pretty much anything yeah yeah and then and then one of them is called like the Python caller so if there’s some Python library you want to leverage you can create your own so yeah it’s super

super powerful yeah so so this is talking a little bit more about the event-driven side of things and in this one Stewart talked a little bit about a schedule but one of the powerful things about RF when you serve a product and if we cloud product you can set a wet book give that web cook to a third-party application and then when something happens now that triggers data flows between these connected applications via their api’s right and then what that does and we’re using this as safe a lot is the connected applications actually provide higher value to the organization than the single products working alone so I think about the how the value we get a things like Trello you know live chat and the community getting all these things connected is just gives you way more visibility of what’s important to you yes yeah now we’ve seen a customer doing this with github yes I have a web watching specific branch on github yeah and every time they push to that branch it triggers a workflow on cloud that goes and looks at the github data and then moves data over to Amazon so that’s you know this event-driven processing it serves to start listening waiting yeah and we’re seeing more and more of these web services have the ability to take a web hook so they can push that out exactly yeah yeah that’s very powerful so this is kind of you need these fault tolerant things to there as well we feel when you’re working with especially doing the synchronization talked about scheduling but you need to be able to retry the requests you know maybe kind of like an exponential back-off key we trying it and then if it fails after 10 minutes and then send an email long yeah you know alert the person who’s not working that’s really really important because she might end up having hundreds of these small little job doing work and you need to no one is an issue yeah you need to know when an API has been deprecated on its timing out it’s in speed and like you said earlier sometimes the service is just down for a period of time and so again you would need to know that yeah okay so first case today we’re going to look at three case studies now that kind of tie in and wrap together everything we’ve talked about okay so the first one is about data access so we’ve been talking about accessing data kind of over traditional api’s like Dropbox jello all these api’s that are docked but what F&E is very good at as well we just want to talk about was pulling data from API endpoints yeah yeah so this is a little few slides from Devon energy they did a talk at our world tour in Calgary and it’s actually on there the wildfires in Alberta which is kind of timely with the devastating fires informant Larry yeah and this is actually very helpful during that period and what’s still ongoing mm-hmm but what they use it for is to have an energy use it basically see if there’s any fires encroaching on the infrastructure right so thanks to my fellow members present this and this is their internal app yeah and they also have a mobile app okay I need this kind of service based architecture yeah and it just shows a you know background mapping of all the actual fires the satellite data with the white smoke on it and then fire incidents so the crucial thing here is the data needs to be to date yeah so really the only place you’re going to get it is over HTTP yeah you’re not going to get a disincentive in no time and you’re really worried if you’re not on the web you want to just access it live yeah so there’s four sources here right so they are birds of government provide wildfire information by CSV and as your feature service CSV yeah yeah British Columbia is there caramel which is like the Google Earth warm up and then we’re pulling background mapping off NASA okay so this is going to be pretty complex mmm it’s pretty complex but the workspace is pretty easy yeah so this is the one pulling the data from the Alberta government yeah yeah so it’s obviously pulling it in CSV which is yeah no location just an XY but you can see with that for me any format if it has HTTP colon as the location of the data right FME just know that hey wait a minute okay that’s I’m going to I’m gonna just go to that link and pull it down exactly so excel file on Dropbox or sheets or anything like that we can have access and pull any basically firebase data such oh yeah time to move it whatever you want to do and then this is more of course you know yeah and here is I’ll put into the geo database and also ArcGIS online putting two three different places to do databases and ArcGIS online exactly and these were all shipped with the product yeah so he just started the reader now right yeah so you can see how simple this is no coding

because in fact I didn’t have to do anything to hit the HTTP there exactly yeah so that’s kind of just to give you an overview of hitting these data sources yeah so the next thing is we’re going to go back to is a data migration right so this is the story about moving into a web service via API yeah so we’re going to talk through one of our own situations essentially and we kind of already brushed on this but we used to have our knowledge base in Salesforce rate so that was the knowledge articles over a thousand knowledge articles a Q&A site and there’s a few other things as well and we also have Trello right yeah where we had all our ideas so we had a Trello board that users who were really motivated could get in there and add ideas for us to put into a product right so we wanted to give willing to get everything in one platform yeah so started looking for products and obviously the first thing we looked at is it have an API yeah the data in yeah so we’re using answer huh yeah and an answer has users articles Q&A and ideas all in one data model yeah but then we wanted to also offer single sign-on yeah so this is a new thing rolling out with safe and it uses our zero yeah and all that is is so that you can log into knowledgebase hub eventually cloud just with one logging yeah so not to lose the data into two user models just triggers yeah so there’s going to be duplicates because of course you had users who were in Salesforce and in trouble exists somehow you had to try to match them to get them together yeah yeah yeah and and also so there was the general challenges yeah but did that run into one who’s doing this can connect any API errors creating a beautiful process but more interesting are the kind of a specific issues that we run into yeah exactly this is the data model in Salesforce on the left and this is the data one with off 0 so the first thing you can see is there’s a lot more information in Salesforce yeah so that needed discarding sure but then all 0 turned out to be a lot more fussy ok and it had to be it’s a web service it has strict login details it didn’t want special characters in the user name there’s character length issues ok and what we found is we started moving data from Salesforce 12-0 we had to clean things up we’d have to remove special characters right now to truncate but then we run into this year we started creating duplicates yes yes so then we have to do very hard yeah and create unique so we did all of that no coding of course yeah and we also have to load the users into answer hub as well yeah so they synched yeah so that was a that was a good problem to do energy the next is loading ideas again this time we were pulling from the Trello API yeah you can see this was an idea for Internet as a file system great idea yeah fantastic idea some customs being commenting and then we had to pull that across over to the ride to the to the model on the right so the one thing here is interesting is if you can see on the right next to the suggested highlight this topics so in answer hook we have this idea of topics and everything was tagged with topics so all we did is we created a massive spreadsheet and then went for each idea we had to say which topic they were associated with and then when we did the migration task we merged the Excel spreadsheet with the Trello API to pull everything across so that was pretty complicated the other thing we had to do as well is when you’re doing an API load it’s a multi-step process so we’ll see that in a later slide that you have to first load the user then get the user ID then you can load the idea and you get the idea ID then you load the comment so it’s a different it’s different way of thinking to when you’re loading into a transactional database you can just go one SQL query after doing steps loading Q&A as well so the key thing here is their loading attachments so all of the attachments were in in Salesforce in their own proprietary system fortunately answer hub let was put them on Amazon so we could catch them and make it fast we have to load the data at timers on then we have to get the URL button and we actually integrate the URL into the content all done with Anatomy so you know we can connect all these web services and we can do it in kind of one step that’s very very easy for the end user to look at to understand if I pass this to you so how much of the effort was I’m connecting to the API is and how much of the effort was just resolving

the data model issues the complicated part is always the data model you need to understand the data model and the data model in this case is the API you know you have to go and look at the API but were there for me you can just pull it in and look at the Jason and you don’t have to also rely on the doc as well but you can see here you know we’re pulling in the ideas from Trello but then we’re pulling in the comments after we’ve done the first load then we’re pulling in the votes on the comments we’re using merges with creating attributes and we’re doing a lot of cleanup and things so there’s a few key transformers there but then really until nowadays it’s more about this manipulation of the data model okay so that’s that’s that example and that’s a book migration and we see a lot of customers doing this as well so third is the application integration so regardless kind of a little demo now just to show you so this demo imagine we just had a big conference we’re providing a Google Form where people can rate the conference so they can give a rating on you know how much you enjoyed the conference of elements to the job and what we want to do is we want to look at their response and based on their response you want to create tasks for people because if they weren’t happy we need to alert sales to contact them and discuss things with them and that’s what we want to do so what we’re going to do is and let’s just walk through this we have a an event feedback form here so I’m going went to my email address here okay and I’m going to rate the event boy wasn’t one of our fictitious event and how relevant okay so I’m going to submit that information and that goes into a Google Form so you can see it should appear in here oh it’s just going to the Google Form so now I have this workspace that runs so that’s some look at that so this workspace it extracts the data from Google sheets because we have a Google sheets reader I’m just you can see here I’m accessing the Google sheets April I with a token and here’s the spreadsheet URL but I’m running this every hour so I only want to look at the inserts that have gone in the last hour so I’m using this date difference calculator transform let’s come from the hub to look at the date compared to now and give me the difference and then I’m just testing to see you know is it less than 3600 seconds so let’s run this we should go out to and do the form all the data room hopefully one of them should pass and then what we’re doing is we’re using the email address to go to Salesforce to pick up all the metadata from Salesforce so you know we need to pull in the phone number we need to pull in the name of the user so that the salespeople can you and turn the Salesforce reader so we can have a picture yeah so yeah yeah so basically you can see there’s this where clause so we’ve hidden again the whole Salesforce API how to talk to it exactly and there’s your where clause which basically is Salesforce syntax no so you know FME when you’re creating these things you don’t have to worry about it you just that’s just past lock stock and barrel yeah Salesforce API underneath yeah yeah and then the logins also I can care of as well yeah with the username and password so we’ve pulled our metadata down now what we’re going to do is use a test a transformer to check the event rating you know did that people think he was axe on average poor offensive and rude hopefully not so based on the response we’re giving away if it’s excellent we’re going to send a message to the team and give praise to the team if it was poor we’re going to send a message to a trophy sales guys can follow up and if it was really bad we’re going to send a message to you so you can jump on it so they twelve weren’t gonna create relic Arg exactly so if we’re going here I have a task now it’s to follow up with the customer and that we’ve actually inserted these you have the poor experience in the recent conference was rated two out of five here is his phone number and here’s his email so the sales guy can now follow up and chase that down and if we just look in the trailer connector here you can see I’m using the action to create a card and if we look in the description here you can see it’s not hard coded we’re using that kind of syntax and pull the information directly from the Google spreadsheet very cool so what are the reactions are there so let’s have a look

yeah so we create a board comment create a list and we can’t get boards so yeah it’s and of course each of these each of those actions underneath was import was correspondent to one or more rest calls right yeah and if we’ve missed one well you could ask us to add it or you could just use the HTTP call and do something or download it from the hub update it and then push it backs up everybody that would be yeah yeah so that’s are just a small dome over the next thing I want to talk about is automating training silence so this is a real life scenario so what it is is when you sign up for training at save software you use goto meeting so you’re going to go to meeting your login but what we want to do is create an automated process essentially to firstly we need to load you into the CRM Salesforce so we have a scheduled tasks that one’s three times a day that hits the go to meeting API and loads of registered users into Salesforce so we’ve previously created it’s called a campaign in Salesforce like a training campaign and we load the users associated with that campaign then Brian or whoever’s doing it gives the training online training that’s free right and the trainer once he’s done he goes into Salesforce and he manually sets the campaigns are completed we then have another fme task that runs and it checks and it looks at the completed campaigns and it says okay which campaigns if completed and not being processed it identifies these campaigns and then what it does is we go out to go to meetings and we pull the attendance information from the go to meeting API so saying done you’re in that webinar but were you actually in the webinar has loads of information getting it in how long you were logged in we paying attention did you last the whole thing and so we pull those statistics in and we look at them and if you meet a certain goal in terms of attendance essentially we send you a certificate by email so now you know how to gain the system mm-hmm but it’s nice because it’s fully automated and we’re meshing together GoToMeeting i’m salesforce mother as well yeah in the past we would do this manually so we had somebody go through and try to figure out you know who actually attended because not everybody who registers actually attend so this has been a big time saver and I enter our clients are happier as well exactly yeah yeah so this just to dive into the details a little bit that the other example showed that because that use the readers the writers that transforms from the home in this example Shane’s build this who used to love to code by the way who who Mary loves FME he used the HTTP koala transformer so let’s look at that is going to webinar go to the GoToWebinar to get session info then he’s getting the webinar attendees then he’s getting their time and some how long has it been paying attention and then he’s loading things into Salesforce yeah and you can see him chaining the different HTTP calls together right yeah and that’s that multi-step process so here’s just I wanted to show you the request URL is going out to Salesforce but the nice thing here is you know you can add crude parameters or headers we support everything but Salesforce has is funky they essentially like to do inline SQL when they’ve been in query that’s fine we can do that and so that’s that’s hard-coded with the campaign ID from an attribute so here he decided to use the Salesforce Salesforce rest call rather than use a Salesforce reader yes and that’s because the Salesforce API has what thousands of API calls we pick out the ones that we think are the most suited to our customers needs yeah but you can do what you want with HTTP call yeah so that’s kind of wrapping things up we’ve covered a lot yes yeah yeah the messages API is really are the key so if you’re implementing new systems make sure they have an API then the next challenge is going to be connecting them together and we’re working hard and FMEA it’s I’m very good at doing that yeah yeah I mean that this is about connecting and we’re going to have a white paper out there’s been three blog posts on this as well talking about this mm-hmm the next webinar in jeans going to be out creating as we’ve said so in an hour we’re gonna walk you through creating an API write a fully functioning client on the Postgres database on our so good so this was about how or or the the what you can do with that for me easily consume them

yeah so that’s great so so that’s there’s some questions here so we’ll go through Soleil okay yeah there’s a few that told me to stop talking so I did that because I get excited and then with the mic I talk over you so thanks for that I appreciate that yeah so there we go somebody said can I create my own mapping services API using FME so I think knows about next time right yeah so the short answer is yes and then in June we’re going to be showing you how to do that so yeah yeah and then is a reason he keeps saying yep yep yep to everything yeah so there ya so that was the one that thing made me be quiet so thanks for that and that the the webinar is going to be available to replant it at a later age yeah we’ll send an email out with an infographic as well and somebody says I have any existing web batch process where I take an address file import into a database tool loaded into a geo coder then have a I T load the result to our production database absolutely you can do that with FME many customers they’ll call out to a geocoding API perform it and then move it directly to the API so that for me is very strong at that yeah and yeah and replicas we do have people who have synchronized there’s one of our we have a good story about that where be people have fused FME to synchronize across databases and again the databases don’t they could be different types of databases they could be the same different a different data models all that kind of stuff so we can do that yes a great question here what I’m creating the workflows can I preview how the data is changing at each step and again in with in FME as you run Stewart just brought it up you’ll see these little dots here if he clicks on any of those dots up comes of the end data inspector that if the data is spatial you’ll see it in a map if it’s not you’ll see a table yeah and if it’s in a map you can look at the attributes as well so absolutely you can do that yeah okay so we can practice yeah so if you yeah so somebody’s morning to learn how to build these up yeah so absolutely you can download FME there’s a you know we’re pretty generous with the free evaluation so you can get going and and then reach out to us now if somebody have a question how can they get in touch with us what’s the easiest way I like the new live chat yeah so if you go to safecom mmm-hmm and right on the home page there in the bottom right corner you’ll see leave a message yeah and we’re online yeah and I think between nine and five Western yeah or you can send a message to the support team but the same message or live chats the best if we’re not there then the message does go to the support team so so yeah so so that’s really easy okay so yeah then there’s questions about spreadsheets I have a spreadsheet has been shared with 50 people kind of get the updates that which person has edited omitted to the spreadsheet if that information is available the answer would be yes we’d want to take a look at that but if the information is not in the spreadsheet and then the answer would be would be no right so okay do you have an API for Yammer yeah no that’s the there’s a social media section really for business I don’t think I think I haven’t looked at it I don’t think we do at this point but if you ever has an API using the things we do now we could easily do that so that would be that would be one and again if you want us to help you with that we’d be happy to learn and and yeah any I mean it’s all throw out any NPI you want to connect to it’s not in our product contact me see me MLS two at the Harper safecom and we will help you connect so in other terms most of the SME transformers are AP is at a lower level like with in FME there are ways you can call them but but really the the unit of work that we expose through a nice API is at the workspace level and you can put fancy api’s on top of a workbench or workspace that you are showing now now we try and hide the the complexities of the API and the readers and writers yeah okay somebody wants we can see somebody ask them as you still got 15 miss can you show a quick example of that 8 Instagram API call so do you have that one handy we showed that one

on the road so here basically you log into Instagram you take a picture so you can take a picture of me hey you take a picture of me no and then I’m slitting Stewart on the spot here to keep talking but but you the answers yeah is really it’s some web so you have to go to say firs there I think you’ll find it and then you go down to web services and then you’ll find team Capital One just works yeah and then it’s a really nice one because it’s really simple it’s one API call and and you’re able to do that and it’s um you know again a toy example but it’s it’s it’s um a lot of fun so that’s not less than that let’s try out a web connection something go to Instagram okay so so it’s doing this live so I’ll have to look at the okay there we go so if we run this now what we’re doing is we’re using the v1 users self medium recent arrest call Resco it’s going to get the most recent picture in my feed yeah and then we are using the JSON extractor to to extract the URL from the return Jason we’re gonna read the image in so what we should see yeah one thing we thought we didn’t mention because we doing so well is the the input and output of many of these rest calls is Jason run and we’ve worked with Jason for many years so that was kind of sometimes you get lucky in this industry and the fact that we had been nailed the Jason Hughes case for so long and then this that was the the the preferred method of sharing data was a nice was a nice win for us so yeah so Stuart quickly extracted the URL for the image from his yeah we use Instagram and so we wrote in the JPEG image in and then we can stop its arrest us so we can do you consider a GC services as a type of API great question yeah we do support I’m og C services from the client side now we’ve baked most of those in so wfs WMS things like that now if there’s another old GC service that you want to hit absolutely you can because at the end of the day an old GC service is an HTTP address in that case the things that are sent back and forth is XML run and so an GML is often the package that comes back so so if you take wfs you’ll see wfs it’s so that’s example of the OGC we should that’s a good should call it o GC wfs I’ll make a note of that yeah and WMS as well and then there’s other ones that you can call and again they may not be there but at the end of the day we have knowledgebase articles and so reach out to us there but absolutely no I think that some that’s great yeah so thanks thanks so and absolutely we can help people connect to API so so you know like reach out to us we’re really excited about this there’s 14,000 of them out there and we’re here to help you know make sure that our flat form is as easy as as possible we’ve got a few training coming a few free training sessions coming up yeah there’s one in June for server and desktop and there is a world there’s a world wide user conference next me so in Vancouver so stay tuned for the announcement so if you want to come to Vancouver or you want to isn’t present on after me learn about FME put that on your calendar for 480 15th so so Thank You Stuart thanks time Stu did all the heavy lifting for sure and and just a great job it’s always fun Stuart and thanks to everybody who came today we really appreciate your time we know that this time is good for some and not so good for for others it’s that it’s that the night in your it is a bit late if only the world was flat maybe it would have been easier but there you go so thank you so much thank you