How do I import an API into a FileMaker solution? Thanks.
You can't just import an API into FileMaker - nor into other platforms I wouldn't think. An API is a set of instructions / rules etc for interfacing with a particular platform, application, programme etc. You would need to work through each of those instructions for whatever the system is to determine how to interface FileMaker with it.
I'm trying to pull students' grades from Engrade. It looked like that would have to be done through an API. So does that mean I will have to find an API string that is attached to grades? Or what would be the best way to do this?
If Engrade has an API you will need to work through each of the rules / instructions in that API and determine if/how you can get FileMaker to interact with it. You may not need to do that however. Can you export data from Engrade in a CSV format? Then you could import it into FileMaker - no API required. Or if you Engrade holds its data in sql tables you could set up FileMaker to connect to those sql tables as an External Data Source and pull the grades in by that method.
You can export grades to CSV. It looks like you would have to save the CSV to your pc, then import it into FileMaker. Is there any way to do this via external data sources (so I wouldn't have to download a new gradebook weekly)?
What database? And would you even have permission to connect directly?
-- sent from myPhone --
It depends on how Engrade stores its data. Read the FileMaker ODBC JDBC guide for more information on setting up external data sources: FileMaker 14 SQL Reference
Importing a csv file on a weekly basis can be scripted and scheduled in FileMaker Server to run every week, which may help in your situation.
It's just a test file I've been working on for a couple days. I don't quite understand your question, would you mind elaborating? Sorry, this is my first built-from-scratch solution.
Thanks Chris, you've been most helpful!
You need to read the API documentation
use the insertFromURL to set a field from, say:
you will get back some XML which you need to parse as it contains a SES key
then use that for further insertFromURL calls as documented
What database is Engrade using (SQL flavor?) and API's typically are set up because there is no direct access to the underlying database from FileMaker. So, studying the API documentation is the best answer to see what is allowed and what is not.
Retrieving data ...