Assuming instead is required, the following 98 results were found.
-
Purpose: Gets a SessionID to use the Auth'n'Auth (Authentication and Authorization) method instead of Oauth Date Created: 2021-09-22 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
on line 344 INSERT using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->insert($db->quoteName('#__my_users')) ->columns(array('name', 'username'))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
this in one workflow because of the delay/lag in that searchRecords will not find the corresponding CRM sales order record. Instead, do the above workflow to attach the files to the Sales Order in Zoho Books, then in your Creator app, do the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit You should get prompted for the Mac/Admin password which you type in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
screenshot: Following the API names in this example, the Deluge code to send would be something like the following instead (reminder: instead of Product_Details, post to the API name in this case "Quoted_Items"): // // init l_CrmLineItems = List(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to match the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the top to display each section....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, and display 12.5% instead of 12.50%. Well there might be a longer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the EU datacenter (zoho.eu) rather than the US datacenter (zoho.com). Update 2023: This solution has been superceded by instead directing the ZohoTicket Attachment trigger (internal webhook in ZohoDesk rather than on Ticket Edit) and creates a row in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for an invoice in ZohoBooks to be sent. How? So the key here is that there were no contact persons on the customer record. Instead, when building the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list)....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of "my_new_database" to the name of your new Joomla 3.0 database (don't change the table prefix for the new Joomla and instead do this as the next step). Rename any instance of "my_new_database.my_prefix_" to the name of your new Joomla 3.0 database...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
A Workaround: New line inserted before and after So this is where I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words))...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
on the row (CR & LF). Fixes of interest: -- assuming This_Decimal="00000.00" or "123456.78" (Do NOT use "Replace" and instead "Add as new column") (DT_DECIMAL,2)TRIM(This_Decimal) -- assuming This_Numeric="0000000.0000" or "1234567.8901"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
field not found","status":"error"}: Happens if you put "JSONstring" instead of "data". Depending on the context of your code (ie. Books API v3=JSONString; CRM API v2=data), you will need to put either. Or your request is missing a field that is required...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
are 2 sets of documentation and the other is that the majority of the documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID from the Shopify sort instead of making Zoho sort a list v_LastID = r_ShopifyProduct.get("id"); } } } // // output info m_Sku_IDs; info m_Sku_IDs.size(); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of zoho.appuri, we are hardcoding the appowner and appname as this is used across Creator apps, ie. images are stored in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Zoho Support as we could be blamed for any website / mail server issues not related to any of this setup / configuration. Instead, we prepare the following set of instructions for the client to give to their IT administrator. If the client registered...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 endpoint of https://www.zohoapis.com/crm/v7/Quotes. Showing Off Just a note here for myself where...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF