Sharepoint Query with SPAPI

1. To use SPAPI query download it from HERE!!!.
2. On SharePoint server under "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS" create folder "SPAPI".
3. Place extracted js files from download to this folder.
4. Put your query within these code lines: 


<script type="text/javascript" src="/_layouts/SPAPI/SPAPI_Core.js"></script>
<script type="text/javascript" src="/_layouts/SPAPI/SPAPI_Lists.js"></script>
<script type="text/javascript">
 
<your spapi query>

</script>

//SPAPI query example:

 
var lists = new SPAPI_Lists('http://url')// SharePoint site URL
var items = lists.getListItems(
'ListName',// SharePoint list name
'',        // SharePoint list view name (for default leave blank)
'<Query><Where><Eq><FieldRef Name="FieldName"/><Value Type="Text">'+Value+'</Value></Eq></Where></Query>', // query
'<ViewFields><FieldRef Name="FieldName"/></ViewFields>', // which field/s to view
1,  // RowLimit
''  // QueryOptions
);

if (items.status == 200)
{
  var rows = items.responseXML.getElementsByTagName('z:row');
 
  for(x=0; x < rows.length; x++) {
  var listValue = rows[x].getAttribute('ows_FieldName'); // query field + ows prefix
    }
}
else
{
  alert('There was an error: ' + items.statusText); // else alert error message
}

Things you should know:
If you use field names with blank spaces you should use field names formatted properly otherwise query will not work. From my experience I use SharePoint Designer to get field names with unsupported characters or blank spaces like this:

1. Connect to your SharePoint site via SharePoint Designer
2. Navigate to "Data Source Library" in upper right section
3. Expand SharePoint lists and find your list from which you want to query fields
4. Right click on the list name and select "Show Data"
5. There you will see all field names with data from current list.
6. Look for your field name (it will be with some different characters like _x0020_).
7. Use this field name in your query.