# Extracting a value from stderr

**URL:** <https://forum.ansible.com/t/extracting-a-value-from-stderr/34780>\
**Category:** Ansible Developer\
**Created:** [March 14, 2021, 10:33am UTC](https://forum.ansible.com/t/extracting-a-value-from-stderr/34780 "2021-03-14T10:33:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Glenn\_Robinson](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@Glenn\_Robinson](https://forum.ansible.com/u/Glenn_Robinson)\
**Post date:** [March 14, 2021, 10:33am UTC](https://forum.ansible.com/t/extracting-a-value-from-stderr/34780/1 "2021-03-14T10:33:30Z")

</div>

I’m using a module which returns some information in the module’s register stderr variable when the module encounters an issue.

Using - debug: var=sql\_delete.stderr returns:

ok: [ibmi01] =\> {  
“sql\_delete.stderr”: {  
“ccsid”: “1146”,  
“curuser”: “GROBINSO”,  
“dftccsid”: “1146”,  
“error”: “\*\*\* error DELETE FROM ANSIBLIB.QCUSTCDT WHERE CDTLMT \< 9999.00”,  
“jobipc”: “\*na”,  
“jobipcskey”: “FFFFFFFF”,  
“jobname”: “QSQSRVR”,  
“jobnbr”: “002988”,  
“jobuser”: “QUSER”,  
“paseccsid”: “0”,  
“syslibl”: “QSYS QSYS2 QHLPSYS QUSRSYS”,  
“usrlibl”: “QGPL QTEMP”,  
“version”: “XML Toolkit 1.9.2”,  
“xmlhint”: “02000:100:Row not found for DELETE.”,  
“xmlhint1”: “02000:100:Row not found for DELETE.”  
}  
}

I want to retrieve the value in the xmlhint item.

When i try and access that value by using:

sql\_delete.stderr.xmlhint

I get a variable not found error.

I’ve tried from\_json, dict2items and dict2list but can’t seem to reference the xmlhint, or any other key values, within stderr.

How do I reference the xmlhint value in sql\_delete.stderr?