Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
SOLVED

Data connection on interactive form not returning result

Avatar

Former Community Member

I have an Adobe interactive form with a data connection that calls an SAP rfc-enabled function module.  The call works fine but it is to return a value in the data connection response.  I know the function module is populating the return variable and the form field binding to the response is correct but it never shows up.  We are on Live Cycle 9.0, with SAP EHP7.  The wsdl and soap connections all look fine. I've tried data connections as "regular" and "execute", have used both hierarchy text fields and directly dragging the data view response field to the form.  I've played with various permutations to the soap and wsdl url's.  The response value is needed so the user see the result of the action (triggered by a button on the form).  Don't know what else to try.  Like I said, the call to the SAP function module works great, it's just the response I can't get back onto the form. Any help resolving this would be greatly appreciated.

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

I finally resolved the issue myself.  Looks like a bug to me.

In my interactive form, I have a button associated to data connection EXTRACT which calls an rfc-enabled function module in SAP called Z_LEMS_EXTRACT.  This function module returns a string result called E_MESSAGE.

The returned E_MESSAGE was then bound to a form text field.

The generated xml code defined the binding as

     Z_LEMS_EXTRACTResponse\.E_MESSAGE

I had to manually change the xml code to

     Z_LEMS_EXTRACT\.Response.E_MESSAGE

This was determined by referring to another interactive form that was created under a previous version of Live Cycle Designer and a previous version of SAP,  It used "\Response." and worked properly.  So I applied the same coding here and it works.

View solution in original post

1 Reply

Avatar

Correct answer by
Former Community Member

I finally resolved the issue myself.  Looks like a bug to me.

In my interactive form, I have a button associated to data connection EXTRACT which calls an rfc-enabled function module in SAP called Z_LEMS_EXTRACT.  This function module returns a string result called E_MESSAGE.

The returned E_MESSAGE was then bound to a form text field.

The generated xml code defined the binding as

     Z_LEMS_EXTRACTResponse\.E_MESSAGE

I had to manually change the xml code to

     Z_LEMS_EXTRACT\.Response.E_MESSAGE

This was determined by referring to another interactive form that was created under a previous version of Live Cycle Designer and a previous version of SAP,  It used "\Response." and worked properly.  So I applied the same coding here and it works.

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----