Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes78 results
Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON
... lowing error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the quick answer is to build a nested map in your request instead of using the Creator/JavaScript period/dot character... Some might suggest it's an authorizat ...
Zoho Creator: Receive JSON via a Shopify Webhook
What? This is an article to document how to receive a JSON response from a webhook created in Shopify. See my article: Zoho Deluge: Push Item to Shopify API if you want information on setting up an integration from Zoho Creator to Shopify A ...
Convert XML UTF-16 to JSON UTF-8 with PHP cURL
... me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load the received XML with SimpleXML and use the built-in PHP JSON_encode function. I ran into the following errors ...
Zoho Billing: Workflow does not exist!
... OST parameters:m_Parameters.toString() content-type:"application/json;charset=utf-8" ]; info r_Response; Do not publish the real API key, organisation ID, customer details, invoice data or record IDs. Production logging should also avoid re ...
Zoho CRM: Add and Update Products from Zoho Analytics Discrepancies
... D",v_ZA_OrgID); m_Params = Map(); m_Params.put("responseFormat","json"); m_Config = Map(); m_Config.put("CONFIG",m_Params); // This example uses the EU data centre. v_Endpoint = "https://analyticsapi.zoho.eu/restapi/v2/workspaces/" + v_ZA_W ...
Zoho Analytics: Sync with Unleashed over API
... ize. Zoho Analytics can connect directly to a Web URL and import JSON, so the better approach was to let Analytics retrieve the product data directly from Unleashed. How? Unleashed requires an HMAC-SHA256 authentication signature generated ...
Zoho Books: getRecordsByID
... ,"123456000000987654","ab_books"); // yields Exception : Invalid JSON Format String r_Item = invokeurl [ url: "https://www.zohoapis.eu/books/v3/items/"+item.get("item_id")+"?organization_id="+organization.get("organization_id") type: GET co ...
Zoho People and Zoho Analytics: Push all Employee Salary Data to Analytics
... m_Config.put("importType","updateadd"); m_Config.put("fileType","json"); m_Config.put("autoIdentify","true"); // update on key m_Config.put("matchingColumns",{"ID"}); // // v2 data m_Params = Map(); m_Params.put("CONFIG",m_Config.toString() ...
Zoho Deluge - Multi-line Variable Assignments and Expressions
... ti-line string concatenation, converted into a map This builds a JSON string over several lines, then converts it into a map so values can be accessed by key. v_InputData = "{" + "\"ID\":\"TEST-1001\"," + "\"FirstName\":\"John\"," + "\"Last ...
ZohoCRM & Xero: Function to pull most recent quotes
... ","Bearer " + v_AccessToken); m_Header.put("Accept","application/json"); m_Header.put("Xero-tenant-id",v_TenantID); // // get CRM invoice details v_TaxRateEndpoint = "https://api.xero.com/api.xro/2.0/TaxRates"; r_XeroResponse = invokeurl [ ...
ZohoCRM & Xero: Function to pull most recent invoices
... ","Bearer " + v_AccessToken); m_Header.put("Accept","application/json"); m_Header.put("Xero-tenant-id",v_TenantID); // // get Xero invoices (page 1 - first 100 - default order is updated date) for each v_Page in l_Pages { m_Params = Map(); ...
Zoho CRM Client Script: Map Quote to Invoice
... a_QuotedSalesOrders = typeof a_QuotedSalesOrders === "string" ? JSON.parse(a_QuotedSalesOrders) : a_QuotedSalesOrders || []; // set first valid sales order ID var v_FirstSalesOrderID = null; // loop through related sales orders for (var i ...