# Celigo not returning output from SQL stored procedure

**URL:** <https://connective.celigo.com/t/celigo-not-returning-output-from-sql-stored-procedure/5944>\
**Category:** Integrator.io\
**Tags:** microsoft-sql, handlebars, netsuite\
**Created:** [December 12, 2025, 6:51pm UTC](https://connective.celigo.com/t/celigo-not-returning-output-from-sql-stored-procedure/5944 "2025-12-12T18:51:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kate\_moore](https://avatars.discourse-cdn.com/v4/letter/k/46a35a/32.png) [@kate\_moore](https://connective.celigo.com/u/kate_moore)\
**Post date:** [December 12, 2025, 6:51pm UTC](https://connective.celigo.com/t/celigo-not-returning-output-from-sql-stored-procedure/5944/1 "2025-12-12T18:51:40Z")

</div>

I'm trying to call a SQL Server stored procedure from a Celigo import flow, and I can’t get Celigo to return the output value. The same stored procedure returns the correct output when I run it directly in SSMS, but when Celigo runs it, the response comes back empty, so there's nothing to map in Response Mapping.

**What I've checked so far:**

- Running the stored procedure directly in SQL Server works and returns the expected output.

- The Celigo SQL connection is fine — the flow runs without errors.

- I set up Response Mapping to capture the return value, but Celigo isn’t receiving anything back.

- The stored procedure uses an `OUTPUT` parameter.

**What I’m wondering:**

- Does Celigo not support reading `OUTPUT` parameters from stored procedures?

- Does the procedure need to `SELECT` a result set instead?

- Is there a specific return format Celigo expects?

**Here’s the SQL I'm executing inside Celigo:**

```auto
DECLARE @ID INT;

EXEC [SAMPLE_DB]
    @IN_MessageID = '1234567',
    @IN_MessageType = 'Message',
    @ID = @ID OUTPUT;

SELECT @ID AS UUID;

```

In SSMS, this returns a value for `UUID`.  
In Celigo, the output is completely empty.

**Has anyone gotten Celigo to capture stored procedure output successfully?** Do I need to change the stored procedure to explicitly return a table with `SELECT`, or is there another way Celigo expects this to be formatted?

Any examples or guidance would be super helpful.

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [December 12, 2025, 7:23pm UTC](https://connective.celigo.com/t/celigo-not-returning-output-from-sql-stored-procedure/5944/2 "2025-12-12T19:23:35Z")

</div>

Are you using a SQL Server import or lookup? If using an import, can you try a lookup instead and see if you get anything?

---

<div class="post-metadata">

**Author:** ![troythompson](https://avatars.discourse-cdn.com/v4/letter/t/ecae2f/32.png) [@troythompson](https://connective.celigo.com/u/troythompson)\
**Post date:** [August 21, 2026, 7:59pm UTC](https://connective.celigo.com/t/celigo-not-returning-output-from-sql-stored-procedure/5944/3 "2026-08-21T19:59:57Z")

</div>

I've had a case open since August of 2025, same problem basically. Celigo Import into SQL databases do not populate the **\_json** object in the response. I've duplicated this in both MS SQL and PGSQL.

When I tried the same SQL statement in a Lookup block instead, the Lookup correctly populated the **data array** in the response. This means the server is at least returning _something_ expected.

I've opened a second case with the PGSQL issue because the workaround of using a Lookup block causes a side effect of the connection hanging open, despite the concurrency setting of 2, the Celigo on-prem Agent will instantly eat 100 connections in 'idle' state, which locks out everyone else from the PGSQL database except admins.

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [August 24, 2026, 4:24am UTC](https://connective.celigo.com/t/celigo-not-returning-output-from-sql-stored-procedure/5944/4 "2026-08-24T04:24:44Z")

</div>

Hey Troy, we’ll see what we can do. The reason it’s currently not returned is because, in the past, customers have put select statements in their queries (since we don’t validate anything on queries), and it causes memory overloads in those cases since imports aren’t meant for that.

That being said, I’m sure we can find a solution, but I wanted to let you know that’s why it’s currently not in place.