Assuming through is required, the following 141 results were found.
-
the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string with this many spaces using leftpad v_GeneratedList = leftpad("...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
How? To resolve this, I'm building on top of my initial GraphQL query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"15:00" } } Inserting as a subform on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee record form is called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
whether to update or create. - Check if Shipment already exists on system to determine whether to update or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the pages to retrieve every product from the WooCommerce system. API connection in WooCommerce So we need to get an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
remove our webhooks. This would make the entire synchronization of the system go out of whack and some records would slip through the net while every day, the process to tidy these all up would leave the data more and more unreliable. So Shopify want...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
*/ // v_CountUnique = 0; v_CountTotal = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_GoalsData = invokeurl [ url :v_Endpoint_Goals type :GET connection:"zpeople" ]; // // parse the response loop through each record returned m_GoalsResponse = ifnull(r_GoalsData.get("response"),Map()); l_GoalRecords =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
: a_QuotedSalesOrders || []; // set first valid sales order ID var v_FirstSalesOrderID = null; // loop through related sales orders for (var i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
")); m_CrmAccount.put("Billing_City",v_XeroAddressCity); m_CrmAccount.put("Billing_Code",v_XeroAddressZip); // // loop through phones for each m_XeroPhone in m_XeroContact.get("Phones") { if(!isNull(m_XeroPhone.get("PhoneNumber"))) { v_XeroPhoneType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
")); m_CrmAccount.put("Billing_City",v_XeroAddressCity); m_CrmAccount.put("Billing_Code",v_XeroAddressZip); // // loop through phones for each m_XeroPhone in m_XeroContact.get("Phones") { if(!isNull(m_XeroPhone.get("PhoneNumber"))) { v_XeroPhoneType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion and designing on a per-app basis so I wanted a standard way of doing it and I'll update this article as I...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
-- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
following someone else's complicated connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
here. No jQuery and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use built-in JSON stringify function newSortedArrayObject =...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in the code above but I'll give the run through using the country of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the exchange fields...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *