Assuming tostring is required, the following 95 results were found.
-
// // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //info "Request Sent to eBay:"; //info x_Params; // // send the request...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
type :GET connection:"zbooks" ]; for each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ----------------------...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_Columns = Map(); m_Columns.put("columns", m_Data); m_Params = Map(); m_Params.put("CONFIG", m_Columns.toString()); // // in analytics, browse to the "Attachments" table and note the URL IDs after workspace and view v_WorkspaceID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
c_ThisOrder.ZohoBooks_Invoice_ID; r_ZB_InvoiceDetails = zoho.books.getRecordsByID("invoices",v_BooksOrgID,v_BooksInvoiceID.toString(),"zbooks"); if(r_ZB_InvoiceDetails.get("invoice") != null) { m_ZB_InvoiceDetails = r_ZB_InvoiceDetails.get("invoice");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
ID") == v_SalesOrderID) { m_Details = Map(); m_Details.put("po_date",m_DataRow.get("PO Date").toDate().toString("dd-MMM-yyyy")); m_Details.put("po_ref",{"value":m_DataRow.get("PO Ref"),"isExternal":true,"link":"https://books.zoho.eu/app/" + v_BooksOrgID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
+ p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the method/type PUT you will use POST with an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
= "https://api.joellipman.com/myapi"; l_UrlParams = List(); for each v_Key in m_Payload.keys() { l_UrlParams.add(v_Key.toString() + "=" + m_Payload.get(v_Key)); } info v_Endpoint + "?" + l_UrlParams.toString("&"); // yields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
m_Params.put("scope","creatorapi") response = invokeurl [ url :v_EndPoint type :POST parameters:m_Params.toString() connection:"myzohocreatorconnection" ]; Successful Response: { "formname": [ "myForm", { "operation": [ "update", { "criteria":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
and David Beckham UK/US Decimal Separator and Commas: v_MyString = 1234.567; v_FormattedString = (v_MyString.round(2)).toString().replaceAll(("(?Link"; v_FormattedString = v_MyString.replaceAll("^.*href\s*=\s*\"([^\"]*)\".*$","$1"); // yields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd")); m_Clone.put("Due_Date",zoho.currentdate.addMonth(1).toStartOfMonth().subDay(1).toString("yyyy-MM-dd")); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= v_XeroTime.replaceAll(v_RegexPattern,"$2",false); info v_ZohoTZ; v_ZohoTimeZone = if(isBlank(v_ZohoTZ), zoho.currenttime.toString("Z"), v_ZohoTZ); info v_ZohoTimeZone; v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_ZohoTimeZone);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // invokeurl r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
m_Data.put("Last_Name","Person"); m_Data.put("id","2"); l_Data.add(m_Data); v_Data = l_Data.toString(); info v_Data; // yields // {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"end_date": "12-12-2021", "percent_complete": "0", "order_sequence": "4", "priority": "None", "custom_fields": m_Custom.toString() }; r_CreateResponse = zoho.projects.create("joelsprojects",45678901234567890,"tasks",m_Params );
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Record Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required fields:\n" + l_Errors.toString("\n"); } else { //... code to submit form/save to record here } Then save the data by adding the record or updating the existing record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
l_FieldsToMonitor.add(input.Opportunity); v_eTag = zoho.encryption.md5(l_FieldsToMonitor.toString()); // // now compare to stored eTag if(v_eTag != input.eTag) { input.eTag = v_eTag; // do the main code that takes into consideration all the fields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
API (change connection name to your own) r_UpdateSO = invokeurl [ url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info r_UpdateSO; } } Source(s): Zoho Community Forums - Zoho Inventory - Error: Please...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *