How to check if record field is empty in API_DoQuery

Question

When I execute API_DoQuery in the Code Page I get the following XML results. detail_note is empty. However,&nbsp; $(this).find("detail_note").text() returns 8 159 True www.yahoo.com 1689364909773 which are the values of the fields below.&nbsp; &nbsp;Does anyone have a suggestion on how check if a field is empty?
&nbsp;
&lt;qdbapi&gt;
&lt;action&gt;API_DoQuery&lt;/action&gt;
&lt;errcode&gt;0&lt;/errcode&gt;
&lt;errtext&gt;No error&lt;/errtext&gt;
&lt;dbinfo&gt;
&lt;name&gt;PDA Supporting Documents&lt;/name&gt;
&lt;desc/&gt;
&lt;/dbinfo&gt;
&lt;variables&gt; &lt;/variables&gt;
&lt;chdbids&gt; &lt;/chdbids&gt;
&lt;record&gt;
&lt;detail_note/&gt;
&lt;support_document/&gt;
&lt;record_id_&gt;8&lt;/record_id_&gt;
&lt;related_pda_support_document___pda_record_id&gt;159&lt;/related_pda_support_document___pda_record_id&gt;
&lt;iscurrentuserrecordowner&gt;True&lt;/iscurrentuserrecordowner&gt;
&lt;support_url&gt;www.yahoo.com&lt;/support_url&gt;
&lt;update_id&gt;1689364909773&lt;/update_id&gt;
&lt;/record&gt;
&lt;/qdbapi&gt;------------------------------Charlene Dougall------------------------------

ryanpflederer3 · Answer

Hi Charlene!
I'd recommend using the RESTful JSON Run Query API instead. It'll provide more clarity on the blank fields you mention, in addition to generally being easier to navigate than XML.------------------------------Ryan Pflederer------------------------------

apostolosgiatsi · Answer

Hello Charlene,

It's a bit tricky to provide a solid answer here without seeing the general structure and logic of your code.
In general, to check for empty tags with jQuery, you first need to parse the XML. Then you can iterate through each tag and check if it's empty (self-closing) like "&lt;detail_note/&gt;.&nbsp;
Here's a simple script to help you get started:

var xmlDoc = $.parseXML(XMLresponse);$(xmlDoc).find('*').each(function() {&nbsp; &nbsp;if ($(this).is(':empty')) { &nbsp; &nbsp; &nbsp; console.log("Empty field found: " + this.nodeName);&nbsp; &nbsp;}}
The above script does the following:

Creates a variable that stores the API Response using the parseXML() function.
Finds all the tags using find()&nbsp;function and then iterates through them.
Checks each node if is empty (no child nodes or text).
Prints on the console the tag name. You can perform any action here with the returned information

Hope that helps!------------------------------Apostolos Giatsidis------------------------------

Forum Discussion

How to check if record field is empty in API_DoQuery