What?
So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP.
Why?
The use-case here is that I have a ...
... connection manager but this is inefficient and not versatile enough to accommodate files that get added later.
Why?
I am creating an extract SSIS package intended to take a text file as its source ...
What?
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud:
Error: The conditional operation ...
What?
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
Why?
If you are simply using a text file as your data source, then ...
... to be unable to handle a lot of code or long URLs such as a base64 source URL for an image.
The Plan
Get company phone and website from Organization Details in ZohoCRM.
Upload and get publicly-accessible ...
What?
An example of code using the new API call "Module Record Count" with some criteria.
Why?
At time of print, I couldn't find an example of how to use this API call with search filters or criteria. ...
... is attached to the last record of the source data
File identifying number is returned from being attached
File is opened in a new tab/window to trigger downloading.
File is deleted from attachments ...
... "Maci", "Macala", "Mack", "Macoy", "Macey", "Macedonia"...
Source(s):
Wikipedia: Category: Compound surnames
Diana, Goddess of the Hunt - Every-Name Index to Family Group Sheets: Mac / Mc
Wikipedia ...
What?
There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...
What?
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday.
Why?
I think it's the US system which generally says that a week starts on a ...
What?
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 ...
What?
One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory:
Why?
Who uses ZohoInventory ...
... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks
Source(s):
ZohoCRM: ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
... string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime()
Source(s)
Zoho CRM v3 Organization API
Zoho Community Forums ...
... "Message: " + r_ZohoShipmentUpdate.get("message");
}
}
}
}
}
}
}
}
Caveat(s):
Limited to 250 requests per day (can be upgraded at a cost)
Source(s):
DH ...
... on each row and then the campaigns as columns.
What we want:
Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3
---------------- --------------- -------------- -------------- ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.