API Tag Archive

Automate Connector Imports

Did you know that you can use a DOS command to import data into Andar? The entire process can be automated with a script that takes your data file, uploads it, and processes the import in one step.

Need Help? We can set this up for you. Call our Help Desk at 877-479-3780.

Although this feature was previously included in the core of Andar, it is now part of the Andar API module and therefore, starting in 2019.01, will require the API license.

IMPORTANT - API Update

Did you know Andar/360 has an API module? With this module, you are able to integrate Andar with virtually any third party product such as Microsoft CRM, or Constant Contact. The Andar API is the recommended tool to use to update Andar from external programs. Updating Andar directly can cause data corruption and disable Andar. Soon, to protect the integrity of your valuable data, we will be locking down the database from changes done directly in Andar's SQL Database. We want to ensure everyone has sufficient time to migrate but every day we wait puts your data at risk. If you are updating Andar through SQL, you should already have a plan in place and be migrating your integration programs to use the API.

Andar/360 will continue to allow external changes through AT LEAST 2019.01.

The API is the best way to provide customers a safe and consistent way to integrate applications while ensuring that we can also continue to grow Andar to meet the requirements of our customers and their unique communities.

Please let us know if you have questions.

Read more about the API...

2018 Andar Users Conference

The planning has began for the 2018 Andar/360 Users Conference. This year's conference will once again be hosted by Butler County United Way and will be held at the Great Wolf Lodge in Mason Ohio. Reserve April 30- May 4, 2018 in your calendar now!

Please be looking for more information later in the year.

Read more...

Andar Integration

Earlier this year, we published Service Pack 2017.01 containing our new standard REST API that provides customers with access and update functions to the Andar database.

A number of customers have independently integrated third party products with Andar through direct access to the database. This has often caused data corruptions and system crashes which take everyone involved significant time and costs to diagnose and correct. Given that many more customers are looking at such integrations, this strategy could quickly spiral out of control. As Andar continues to grow and evolve, it becomes increasingly likely that some customer integration points could fail, corrupt data or cause Andar to fail altogether.

That is why we have created the API. This will provide a secure, reliable and non-corrupting data entry point for Andar. We have reached out to customers and service providers to work with us to ensure that the API provides the necessary functions.

Although we have suggested a mid-2018 date for everyone to switch to the new API, we are flexible and likely to extend this date to ensure everyone has sufficient time to migrate.

The intent here is to enable customers to safely integrate applications while ensuring that we can also continue to grow Andar to meet the requirements of our customers and their unique communities.

We encourage customers with specific requirements to add them to project 103722.

Read about the API...

Read and add to project 103722...

Andar API

Are you using SQL functions to change Andar data? Do you have integration software to move data from other applications into Andar? These functions can often corrupt your database. We are working to protect your database and as such, we have released a new API module that will ensure data is loaded into Andar correctly and securely. Get ahead of the curve, start migrating your integration software to use the new API now. We intend to prevent external changes to the Andar database in later 2018 or early 2019.

Read more...

Andar API

Earlier this week, we published Service Pack 2017.01 containing our new standard REST API that provides customers with access and update functions to the Andar database.

A number of customers have independently integrated third party products with Andar through direct access to the database. This has often caused data corruptions and system crashes which take everyone involved significant time and costs to diagnose and correct. Given that many more customers are looking at such integrations, this strategy could quickly spiral out of control. As Andar continues to grow and evolve, it becomes increasingly likely that some customer integration points could fail, corrupt data or cause Andar to fail altogether.

That is why we have created the API. This will provide a secure, reliable and non-corrupting data entry point for Andar. We have reached out to customers and service providers to work with us to ensure that the API provides the necessary functions.

Although we have suggested a mid-2018 date for everyone to switch to the new API, we are flexible and likely to extend this date to ensure everyone has sufficient time to migrate.

The intent here is to enable customers to safely integrate applications while ensuring that we can also continue to grow Andar to meet the requirements of our customers and their unique communities.

We encourage customers with specific requirements to add them to project 103722.

Read about the API...

Read and add to project 103722...

ALERT - Andar API

Coming in 2018: We are planning additional security and data integrity measures in Andar to protect your information. These changes are expected to significantly modify the Andar database to the point where external integration tools (if any) accessing or modifying your Andar database directly are likely to fail or cause Andar to fail. Such external database changes are not supported under our maintenance agreement.  If you have any external applications which modify your Andar database, you are strongly advised to modify your processes to use the new Andar API. Customers importing data elements not currently supported by Andar Connector (Andar API) should immediately advise us so we can plan enhancements to the API.

Andar API

New in Service Pack 2017.01: We are releasing a new API module for Andar. With this module, your programmers will be able to integrate Andar with virtually any third party product such as SalesForce, Constant Contact, etc.

What’s an API? An Application Program Interface (API) is a documented communication that you can use to move data between Andar and other applications. Here is a YouTube video (https://youtu.be/7YcW25PHnAA) that shows how APIs work in general. Andar works the same way.

Read projects 100713 and 102690...

Andar API

New in Service Pack 2017.01: We have built an API for Andar! Now larger organizations with various other software products can easily exchange data amongst applications. The API can retrieve information as well as add, update, and delete various information in Andar. The API is a separate module that will also require e-Community and Executive Plus.

Read projects 100713 and 102690...