to know the type of input the flow is accept

(0) Share

Report

Posted on by msireesha

Hi,

I'm sending Json data from power apps to power Automate flow by,

WASHERAPPFLOW.Run(arrTag,WASHER_json).

When seeing the trigger input it is JSON array. So, I want to take first JSON with an Expression to insert the data to stored procedure.

first(outputs('Compose_T5095_WASHER_TXN')).

got me an error :

Oracle: ORA-40441: JSON syntax error
ORA-06512: at "SYS.JDOM_T", line 9
ORA-06512: at "SYS.JSON_OBJECT_T", line 115
ORA-06512: at "GLOBUS_APP.PAP_SAVE_WASHER_APP_TXN", line 22
ORA-06512: at line 2

inner exception: Oracle: ORA-40441: JSON syntax error
ORA-06512: at "SYS.JDOM_T", line 9
ORA-06512: at "SYS.JSON_OBJECT_T", line 115
ORA-06512: at "GLOBUS_APP.PAP_SAVE_WASHER_APP_TXN", line 22
ORA-06512: at line 2

clientRequestId: 70735f3d-f393-490c-b3f3-5d023ec96002

@timl

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

I think the problem is, that the input is still treated as a String and not as an array.

The easiest option would be to put it in the "Parse JSON" action and fork from there with the created array.

You could also try to create an Array variable with your input as value.

Was this reply helpful? Yes No
msireesha 32 on at

Like (0)

Report

Hi @okeks ,
My stored procedure will accept two parameter first one will accept Json object and second will accept Json array.
anyway,I have found the solution but I want to know the input type the flow is treating.

@okeks If the right parameter is treated as string, the left parameter is accepted in the stored procedure.

Was this reply helpful? Yes No