API-Designer.md

@@ -88,7 +88,13 @@ To select (firstname, lastname) of Contacts record where email field value match
 	        <field name="lastname"> </field>
 	    </record>
 	    <where>
-			<field name="email" value="@email_address"> </field>
+	        <field name="reportsto" module="Contacts">
+                    <select>
+                        <where>
+                            <field name="email" condition="eq" value="@emailaddress"></field>
+                        </where>
+                    </select>
+                </field>    
 	    </where>
 	</select>
     </api>
@@ -180,8 +186,10 @@ To replace email field value with incoming parameter (new_email) on all Contacts
 
 #### Upsert
 
+You can update and create in one single api
 
 ```
+<?xml version="1.0" ?>
     <api method="post" module="Contacts">
         <upsert>
             <where>
@@ -234,7 +242,7 @@ Using bearer token invoke Google Sheet API
 <?xml version="1.0" ?>
     <api method="get">
 	<rest>	                         
-            <url>https://sheets.googleapis.com/v4/spreadsheets/sheetID</url>
+            <url sheetID="@sheetid">https://sheets.googleapis.com/v4/spreadsheets/$sheetID</url>
 	    <auth>
 	        <bearer token="@token" />
 	    </auth>