topic Re: Fabric Notebook ExitValue how to select specific values in Data Engineering

Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 22 Jan 2026 01:03:48 GMT

Hi,

I had a question in the Fabric Notebook.

In Fabric Notebook , From the ExitValue below output in Notebook , how to select specific value , like only schema and table and need to select values of schema and table output in Notebook.

ExitValue: {"parent1": {"name": "test", "Details": {"status": "active", "schema": "dbo","table" : "employee}}}

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 22 Jan 2026 03:13:48 GMT

@pallavi_r - Can you please help and suggest.

Re: Fabric Notebook ExitValue how to select specific values

pallavi_r — Thu, 22 Jan 2026 04:38:01 GMT

Hi @Ka13 ,

The exitvalue returned from mssparkutils.notebook.run() is always a string. We need to first parse into json using function - json.loads to access its element. Please see the below code.

import json

parsed = json.loads(exit_value)

schema = parsed["parent1"]["Details"]["schema"]

table = parsed["parent1"]["Details"]["table"]

The above code worked for me. Please see and let me know if it resolves this issue.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi_r

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 22 Jan 2026 05:00:16 GMT

Thanks Pallavi for your reply.

Can we pass the above ExitValue from one notebook to another Notebook activity and access the values of schema and table in another Notebook?. Can you please suggest

Re: Fabric Notebook ExitValue how to select specific values

pallavi_r — Thu, 22 Jan 2026 05:05:52 GMT

Hi @Ka13

Yes definitely. Please see this. Below code is written in 2nd notebook calling another notebook.

exit_value = mssparkutils.notebook.run(

"nb_begin",

timeout_seconds=60

)

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Fri, 27 Feb 2026 15:54:45 GMT

Thanks Pallavi, in Details if we have one more field of columns like - id,name,city,country. And to extract columns.

can you please suggest.

Re: Fabric Notebook ExitValue how to select specific values

pallavi_r — Thu, 22 Jan 2026 06:12:32 GMT

Hi @Ka13 ,

So here we need frame a dynamic sql. in the previous one we had parsed the string into json. Now we have to retrieve all the column names into string literal in a python list.

details = parsed["parent1"]["Details"]

schema = details["schema"]

table = details["table"]

columns = details["columns"]

getcol = [

f"CAST({col} AS STRING) AS {col}"

for col in columns

]

Then to create a dynamic sql expression, we need to merge all the elements from the above list into a single comma separated string using ",".join(column)

select_query = f"""

SELECT

{", ".join(getcol)}

FROM {schema}.{table}

"""

print(select_query)

working code below:

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 22 Jan 2026 06:30:29 GMT

Thanks Pallavi, can we pass this select query formed to the next activity ( Copy Activity) ? , to execute the query. Will test the above and let you know if any questions.

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 22 Jan 2026 14:56:57 GMT

Hi Pallavi, can we pass this formed select query in next Copy Activity?

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 22 Jan 2026 17:55:08 GMT

Hi Pallavi,

in the getcol , the column names are getting split as below . Can you please suggest

ID - AS I , D AS D

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Fri, 23 Jan 2026 07:27:19 GMT

Hi Pallavi, can we pass this formed select query in next Copy Activity?

Re: Fabric Notebook ExitValue how to select specific values

pallavi_r — Fri, 23 Jan 2026 09:59:24 GMT

Hi @Ka13

Sorry for late reply. Can you please send me the exit value and parsed.

exit_value = mssparkutils.notebook.run(

"nb_first",

timeout_seconds=60

)

exit_value

and this one

import json

parsed = json.loads(exit_value)

parsed

Thanks,

Pallavi

Re: Fabric Notebook ExitValue how to select specific values

pallavi_r — Fri, 23 Jan 2026 11:00:22 GMT

Hi @Ka13 ,

Yes we can read this query in a copy activity. First convert this select query to json

import json

from notebookutils import notebook

nb_result = {

"select_query": select_query

}

notebook.exit(json.dumps(nb_result))

Then in pipeline add notebook activity and connect to copy data. In the dynamic content of copy data, add this json expression.

@json(activity('Notebook1').output.exitValue).select_query

This works.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi_r

Re: Fabric Notebook ExitValue how to select specific values

v-prasare — Wed, 28 Jan 2026 09:29:30 GMT

Hi @Ka13,

You can pass the formed SELECT query to the next Copy Activity by exiting the notebook with the query as JSON and referencing it using dynamic content in the Copy Activity source. This method works reliably in Fabric pipelines and is the recommended way to execute dynamic SQL from a notebook

Thanks,

prashanth

MS fabric community support

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Thu, 29 Jan 2026 05:52:26 GMT

Thanks Prasare, will test and let you know if any issues.

Re: Fabric Notebook ExitValue how to select specific values

v-prasare — Fri, 30 Jan 2026 17:19:13 GMT

Hi @RajK2,

thanks for explaining the scenario. To better understand the issue and provide an accurate solution, could you please share a small set of sample data (with any sensitive information removed) along with the expected output? This will help ensure the guidance is aligned with your exact requirement.

Thanks,

Prashanth

MS fabric community support

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Mon, 02 Feb 2026 16:42:33 GMT

Hi Prasare , I tried the below solution provided by Pallavi it worked

In Notebook

import json
from notebookutils import notebook

nb_result = {
"select_query" = select_query
}

notebook.exit(json.dumps(nb_result))

Then in pipeline, added notebook activity. In the dynamic content added the json

@Anonymous(activity('Notebook1).output.exitValue).select_query

Re: Fabric Notebook ExitValue how to select specific values

Ka13 — Mon, 02 Feb 2026 16:43:15 GMT

Thanks Pallavi tested above it's working