Execute Stored Procedure V2 body parsing

Like (0) Share

Report

Posted on 14 Mar 2022 09:28:27 by DanielPineault

113

I have a flow the takes an HTTP response an then uses an Execute Stored Procedure V2 to import the data into an SQL Server db. This all works fine.

Now, I want to have the Store Procedure return a string containing multiple bits of information: status (Success, Failure), identity, ... for a total of 4 elements so they can be use to build and send the appropriate e-mail to the user.

My question is, how can I parse the Execute Stored Procedure V2 return so as to split the return into individual variable for used thereafter? What action?

Thank you.

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DanielPineault 113 on 14 Mar 2022 at 09:50:14

Like (0)

Report

Re: Execute Stored Procedure V2 body parsing

Entirely my fault, wrong brackets! For anyone else, should be

split(outputs('Execute_stored_procedure_(V2)')?['body'], '|')[0]

Was this reply helpful? Yes No
DanielPineault 113 on 14 Mar 2022 at 09:42:19

Like (0)

Report

Re: Execute Stored Procedure V2 body parsing

I tried building a Initialize Variable action with a Value of

split(outputs('Execute_stored_procedure_(V2)')?['body'], "|")[0]

but it won't allow it?

Was this reply helpful? Yes No