insertRecords-Methode – Vergleich

Zweck

Einen bestimmten oder mehrere Datensätze erstellen/einfügen.

Anfrage-URL

Version 1.0:

https://crm.zoho.com/crm/private/xml/Leads/insertRecords?authtoken=AuthToken&scope=crmapi&xmlData=Your XML Data

Version 2.0:

URL: https://www.zohoapis.com/crm/v2/Leads

Methode: POST

Textkörper der Anfrage: Der Inhalt eines im JSON-Format angegebenen Datensatzes.

Header: Authorization=Zoho-oauthtoken {oauth_token}

Anfrageparameter

Version 1.0	Version 2.0
authtoken=****	Authorization=Zoho-oauthtoken *** - als Header**.
scope=crmapi	K. A.
xmlData	K. A. - Eingabedaten müssen im Textkörper der Anfrage angegeben werden
wfTrigger=true	“trigger”:[“workflow”,”approval”,”blueprint”] Der oben genannte Schlüssel muss im Textkörper der Anfrage angegeben werden
duplicateCheck	Dublettenprüfung wird standardmäßig durchgeführt.
isApproval	“trigger”:[“workflow”,”approval”,”blueprint”] Der oben genannte Schlüssel muss im Textkörper der Anfrage angegeben werden
newFormat	K. A.
Version	K. A.

Beispiel für API-Anfrage:

Anfrage in Version 1.0	Anfrage in Version 2.0
https://crm.zoho.com/crm/private/xml/Leads/insertRecords?authtoken=****&wfTrigger=true&xmlData=<Leads><row no="1"><FL val="Last Name">test1</FL><FL val="Company">com1</FL></row></Leads>	URL - https://www.zohoapis.com/crm/v2/Leads Textkörper: { "data": [ { "Last_Name":"Ben", "Company":"Zylker" } ], “trigger”:[“workflow”,”approval”,”blueprint”] }

Beispielantworten:

Antwort in Version 1.0	Antwort in Version 2.0
<?xml version="1.0" encoding="UTF-8" ?> <response uri="/crm/private/xml/Leads/insertRecords"> <result> <message>Record(s) added successfully</message> <recorddetail> <FL val="Id">1386586000002579001</FL> <FL val="Created Time">2018-03-2719:21:54</FL> <FL val="Modified Time">2018-03-2719:21:54</FL> <FL val="Created By"><![CDATA[Bruce Wills]]></FL> <FL val="Modified By"><![CDATA[Bruce Wills]]></FL> </recorddetail> </result> </response>	{ "data": [ { "code": "SUCCESS", "details": { "Modified_Time": "2018-03-27T19:20:28+05:30", "Modified_By": { "name": "Bruce Wills", "id": "1386586000000078001" }, "Created_Time": "2018-03-27T19:20:28+05:30", "id": "1386586000002572002", "Created_By": { "name": "Bruce Wills", "id": "1386586000000078001" }, "display_name": "Deb", "type": "recycle", "Created_By": { "name": "Bruce Wills", "id": "1386586000000078001" } }, "message": "record added", "status": "success", } ] }

Antwort in Version 1.0

Antwort in Version 2.0

<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/crm/private/xml/Leads/insertRecords">
<result>
<message>Record(s) added successfully</message>
<recorddetail>
<FL val="Id">1386586000002579001</FL>
<FL val="Created Time">2018-03-2719:21:54</FL>
<FL val="Modified Time">2018-03-2719:21:54</FL>
<FL val="Created By"><![CDATA[Bruce Wills]]></FL>
<FL val="Modified By"><![CDATA[Bruce Wills]]></FL>
</recorddetail>
</result>
</response>

{
  "data": [
   {
    "code": "SUCCESS",
    "details": {
     "Modified_Time": "2018-03-27T19:20:28+05:30",
     "Modified_By": {
      "name": "Bruce Wills",
      "id": "1386586000000078001"
     },
     "Created_Time": "2018-03-27T19:20:28+05:30",
     "id": "1386586000002572002",
     "Created_By": {
      "name": "Bruce Wills",
      "id": "1386586000000078001"
     },
    "display_name": "Deb",
    "type": "recycle",
    "Created_By": {
     "name": "Bruce Wills",
     "id": "1386586000000078001"
     }
    },
    "message": "record added",
    "status": "success",
   }   ] }

Hinweis:

Das Feld "id" in API Version 1.0 ist äquivalent zu "id" im ersten JSON-Objekt des JSON-Array "data".

Änderungen des Eingabeformats für das Moduls "Activities":

Version 1.0	Version 2.0
<Events><row no="1"> <FL val="Subject">Title3</FL> <FL val="Start DateTime">2018-04-1111:00:00</FL> <FL val="End DateTime">2018-04-1112:00:00</FL> <FL val="CONTACTID">1386586000002379006</FL> <FL val="SEID">1386586000001570009</FL> <FL val="SEMODULE">Accounts</FL> </row> </Events>	{ "data": [ { "Event_Title":"titl1", "Start_DateTime":"2018-04-11T11:00:00+05:30", "End_DateTime":"2018-04-11T12:00:00+05:30", "Who_Id": "1386586000002379006", "$se_module": "Accounts", "What_Id": "1386586000001570009" } ] }

Hinweis:

CONTACTID ist äquivalent zu id im JSONObject Who_Id.
SEMODULE ist äquivalent zu $se_Modul.
SEID ist äquivalent zu Was_Id-JSONObject.

Änderungen des Eingabeformats für das Modul "Inventory":

Version 1.0	Version 2.0
<Invoices><row no="1"> <FL val="Subject">test inv2</FL> <FL val="ACCOUNTID">1386586000002307022</FL> <FL val="Tax">1.23</FL> <FL val="Adjustment">5</FL> <FL val="Grand Total">305</FL> <FL val="Product Details"> <product no="1"> <FL val="Product Id">1386586000000097001</FL> <FL val="Unit Price">10.0</FL> <FL val="Quantity">3.0</FL> <FL val="Total">300.0</FL> <FL val="Discount">1.23</FL> <FL val="Total After Discount">288.77</FL> <FL val="List Price">100.0</FL> <FL val="Net Total">288.77</FL> </product> </FL> </row> </Invoices>	{ "data": [ { "Adjustment": 5, "Product_Details": [ { "product": { "id": "1386586000000097001" }, "quantity": 3, "list_price": 100, "unit_price": 22, "line_tax": [{"percentage": 2,"name": "Sales Tax"},{"percentage": 3,"name": "Vat"}] } ], "Subject": "test inv4", "Account_Name": "1386586000000753001", "$line_tax": [{"percentage": 1,"name": "Sales Tax"},{"percentage": 0.5,"name": "Vat"}] } ] }

Version 1.0

Version 2.0

{
  "data": [
   {
    "Adjustment": 5,
    "Product_Details":
    [
     {
      "product": {
       "id": "1386586000000097001"
      },
      "quantity": 3,
      "list_price": 100,
      "unit_price": 22,
      "line_tax": [{"percentage": 2,"name": "Sales Tax"},{"percentage": 3,"name": "Vat"}]
     }
    ],
    "Subject": "test inv4",
    "Account_Name":
    "1386586000000753001",
    "$line_tax": [{"percentage": 1,"name":
    "Sales Tax"},{"percentage": 0.5,"name": "Vat"}]
   }
  ]
}