FileMaker integration with Open Epic

[Selva]

Dear All,

We have planned to integrate Open Epic with FileMaker. We are using FileMaker AWS cloud, so it does not support CWP. Is there anyway to import/export the Epic data with FileMaker?

Please let us know.

Thanks in advance,
Selvakumaran.K

[Fitch]

Have you looked at their API?

Welcome to the forums.

[Wim Decorte]

If you are using some other system's APIs then you don't need FM's web publishing at all.  It all happens with the "insert from URL" script step.

As with any integration you have to decide which system will be making the calls to the other system.  If you decide that "open epic" will talk to FM then you will need one of the FM APIs: XML, Data API or ODBC/JDBC.

If FM will talk to Open Epic then it is just straightforward "insert from URL" cURL calls.

[Selva]

On 4/9/2020 at 11:38 PM, Fitch said:

Have you looked at their API?

Welcome to the forums.

Hi Fitch,

We haven't checked the APIs. We have asked them the API information for reference.

Thanks.

[Selva]

On 4/10/2020 at 1:12 AM, Wim Decorte said:

If you are using some other system's APIs then you don't need FM's web publishing at all.  It all happens with the "insert from URL" script step.

As with any integration you have to decide which system will be making the calls to the other system.  If you decide that "open epic" will talk to FM then you will need one of the FM APIs: XML, Data API or ODBC/JDBC.

If FM will talk to Open Epic then it is just straightforward "insert from URL" cURL calls.

Hi Wim,

We have hosted our solution in "FileMaker Cloud for AWS" and it will be used only in FileMaker WebDirect. Can the above mentioned features will support in Cloud/Web? Also please let us know the cURL/JSON features which will supports for connecting with other systems.

Thanks.

[Wim Decorte]

You haven't really answered my question so it is not clear which direction your integration will be.  If you are in FM and need to talk to Epic then yes it will work from that version of FMS.

And the cURL /Json features that you'll need are the FM "insert from URL" script step (with its support for cURL) and the JsonGetElement(), jsonSetElement() and related functions to create and parse the necessary Json.