You have several options to integrate your database with Higher Logic Real Magnet.
Real Magnet API (REST)
Use this REST API to connect your database to Real Magnet. Aside from the traditional XML, our REST API also allows for JSON, a popular method of transmitting data that is easier to parse. Many programming languages (e.g., .NET, PHP, Coldfusion) support JSON. Using this REST API includes independent functionality like the ability to upload a list of recipients, send through HTML to create a message, and send a message to a group.
Upload and Send API (REST)
The Upload and Send API is designed to batch the uploading of a list and sending of a message, as quickly as possible, in one API call or submission. The submission includes just the list of up to 10K recipients, the HTML/TEXT content, and the sending details (i.e., subject line and from address). In this process, there is no ability to manage the message for message category, folder, or name. Similarly, this API creates a new group and there is no management of the group. Lastly, the message is scheduled to be sent immediately, meaning it's queued during the submission to the API and will be sent as soon as possible.
Simple Data Transfer (FTP)
Simple Data Transfer (Simple DT) is a method to upload a list of recipients or on a schedule when no direct integration is available to an AMS or CRM. This solution is designed to access data files on an FTP location. If needed, Real Magnet can host an FTP location for you. With Simple DT, there is an upload configuration tool in Real Magnet to map the files on the FTP location to specific groups. This is managed through the Real Magnet interface instead of being handled programmatically.
File Upload API (FTP)
This API is used to trigger upload jobs only using FTP technology. File Upload API can be used for larger data sets because the use of FTP will improve the transmission speed of the actual data set between two networks. It's important to note that this API will only queue and process the upload with parameters designated. These processing parameters could include replacing a group or splitting the list of recipients into sampling groups. This API does not transfer files to Real Magnet. This is handled programmatically instead of through the Real Magnet interface.