Please let me know how do I pass apostrophe in Inputs parameter for executestoredprocedure function
ocal!sp: fn!executestoredprocedure( dataSourceName: "jdbc/DRO", procedureName: "procCSS_Search", inputs: { { name: "ssn", value: ri!ssn }, { name: "lastname", value: ri!lastName }, { name: "firstname", value: ri!firstName }, { name: "caseid", value: ri!caseId }, { name: "primaryCauseTF", value: ri!primaryCauseTF }, { name: "causenum", value: ri!causeNum }, { name: "oagnumber", value: ri!oagNumber }, { name: "personid", value: ri!personId }, { name: "phone", value: ri!phone }, { name: "casestatus", value: ri!caseStatusCode }, }, timeout: 300 ),
Discussion posts and replies are publicly visible
Use double-quotes to add a add a single quote to your text.
Example: "this "" is a quote"
Is this what you are looking for?
BTW, there are new function to execute stored procedures. Check this: docs.appian.com/.../Execute_Stored_Procedure_Smart_Service.html
I completely agree with stefan and for input parameter its good the use procedure inputs
'type!{urn:appian:plugin:executestoredprocedure:types}ProcedureInput'()