Fetch data from a Data model

[tommyk80763269]

Hi,

I have seen a sample where a HTML5 form is calling a Data Model on an event.

What we are looking for is the possibility to add some data and use that to call a DM.

Anyone that could point me in the right direction or have a sample?

regards

Tommy

[tommyk80763269]

What I meant, I couldn´t find the sample I was looking for.

//Tommy

[Jared_Langdon]

What do you mean by "add some data"?  Do you mean, for example, user enters the ID of a database record and you fetch that using a get service defined in your data model?  I can walk you through that, but first please clarify if that's what you need.

[tommyk80763269]

Hi Jared,

Yes, that is what I am looking for. Add an id an call a service defined in a data model.

Regards

Tommy

[Jitendra_S_Toma]

Tommy,

So if I understand your question correctly, you want to pass some id (i.e data) from your form to Data model and same data or id can be used in service. Service is part of your data model.

Is that correct?

[tommyk80763269]

Yes, that is correct

[Jared_Langdon]

First, make sure you have AEM 6.3 with SP1 or higher.  I would suggest starting with this article:

https://helpx.adobe.com/experience-manager/6-3/forms/using/data-integration.html

You will learn there how to configure data sources.  Once you have a data source created, add a get service and test it as described in the article.

When you got that going, check out this article:

https://helpx.adobe.com/experience-manager/6-3/forms/using/data-integration.html

You might want to go straight to the section "invoke form data model example".

I was able to get this working with a relational database.  Hope this helps.

[tommyk80763269]

Hi Jared,

I couldn't find the sample "invoke form data model example" at

https://helpx.adobe.com/experience-manager/6-3/forms/using/data-integration.html

Have I missed something?

Regards

Tommy

[Jared_Langdon]

Sorry.  This one:

https://helpx.adobe.com/experience-manager/6-3/forms/using/rule-editor.html#example

[tommyk80763269]

Hi Jared,

but isn't this only for Adaptive Forms? Did you  use  a HTML5 form on your test?

If you did, could you send me the xdp?

regards

Tommy

[kjaeggin · Accepted solution]

Tommy,

The form Data model is meant to work with Adaptive Forms authoring.

Please see [1]. 

For HTML5 forms, most features work the same as they do in PDF. Here is a list of the differences at [2].

If you setup an OLEDB connection in your XDP to pass data into your form, I believe the DB connection should still work server side. I'm not sure if the connection is supported on the client. 

I have not tried this myself in HTML5 forms, but most of the XFA constructs [2] are still supported server side if I am not mistaken.

[1]  Adobe Experience Manager Help | AEM Forms Data Integration

[2] Adobe Experience Manager Help | Feature differentiation between HTML5 forms and PDF forms

[smacdonald2008]

Nice response Kevin!