# Stored procedure execution

**URL:** <https://forum.radzen.com/t/stored-procedure-execution/6686>\
**Category:** Angular\
**Created:** [February 15, 2021, 4:54pm UTC](https://forum.radzen.com/t/stored-procedure-execution/6686 "2021-02-15T16:54:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![markb](https://forum.radzen.com/letter_avatar_proxy/v4/letter/m/a8b319/32.png) [@markb](https://forum.radzen.com/u/markb)\
**Post date:** [February 15, 2021, 4:54pm UTC](https://forum.radzen.com/t/stored-procedure-execution/6686/1 "2021-02-15T16:54:50Z")

</div>

I suspect this isn't possible but, asking on the off chance that I have missed something...

When adding a handler to invoke a data source method on a stored procedure, Radzen generates the server as a HttpGet. Is it possible to specify that these should be generated as HttpPost with the parameters passed FromBody instead?

---

<div class="post-metadata">

**Author:** ![enchev](https://forum.radzen.com/user_avatar/forum.radzen.com/enchev/32/16_2.png) [@enchev](https://forum.radzen.com/u/enchev)\
**Post date:** [February 15, 2021, 6:48pm UTC](https://forum.radzen.com/t/stored-procedure-execution/6686/2 "2021-02-15T18:48:50Z")

</div>

There are two ways for executions of a stored procedure:

1. The procedure that will return data:  

2. General stored procedure execution:  

More info about how Radzen will decide which approach will be used to execute the procedure can be found here:

> [@Stored Procedures missing from interfered schema](https://forum.radzen.com/t/stored-procedures-missing-from-interfered-schema/320/2):
>
> Hi Josh, Radzen uses [sys.dm\_exec\_describe\_first\_result\_set\_for\_object](https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-describe-first-result-set-for-object-transact-sql?view=sql-server-2017) which requires SQL Server 2012. Best regards, Atanas

In both cases HttpGet will be used. If you need HttpPost you can create custom method and use one of the two approaches to execute stored procedure.

---

<div class="post-metadata">

**Author:** ![markb](https://forum.radzen.com/letter_avatar_proxy/v4/letter/m/a8b319/32.png) [@markb](https://forum.radzen.com/u/markb)\
**Post date:** [February 16, 2021, 9:30am UTC](https://forum.radzen.com/t/stored-procedure-execution/6686/3 "2021-02-16T09:30:38Z")

</div>

That's perfect. Thanks for the information and I've now got a working custom method solution 😃