What?
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay.
Why?
Our use-case is a data migration from eBay to a fresh instance ...
... hasn't been populated
l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100;
for each c_Appt in l_Appointments
{
//
// get package references ...
... to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the page and check it out as well as the client to go in and confirm the change was ...
... on line 86
Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead:
m_NestedRequest = Map();
m_NestedRequest.put("auth[key]",v_AuthKey);
m_NestedRequest.put("auth[secret]",v_AuthSecret);
m_NestedRequest.put("data[member_id]","123456");
m_NestedRequest.put("data[channel_name]","shopify");
m_NestedRequest.put("data[item_name]","Joel ...
... date format), arrange so it can be sorted alphabetically in reverse order
v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd");
v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5);
v_SqlDateTime ...
... going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a month in one go - increase the submonth/addmonth parameter if an employe ...
... 25)) );
}
// output
v_Output= l_Output.toString("");
return v_Output;
}
Additional Notes:
As this was for a client who arranged outdoor activities for kids, I need to add ...
... is a function to multiply two ranges together (must be the same size) and return the total of these results.
-- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0.
IsNumber( ...
... As Range
Dim xRow As Range
Dim SplitRow As Integer
Dim xWs As Worksheet
On Error Resume Next
xTitleId = "JoelsTooCoolForExcel"
Set WorkRng = Application.Selection
Set ...
... Air Base 40°8′57″N 116°19′17″E
Beijing Tongxian Air Base 39°48′40″N 116°42′30″E
Note that I tend to copy the coordinates off a website which has strange apostrophes and ...
... a new module (Insert > Module)
Copy and Paste the Excel user defined function belowSub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End ...
... [1.7.2] News: Fix for duplicate feeds
- [1.7.1] Hangar: backwards compatibility for this app
- [1.7.0] Map: toggle city centres
- [1.7.0] Map: toggle map type
- [1.7.0] Map: change blue zone range
- ...
... each process.
Stu-Talk Monitor Process (SMP): Counts the DOTs with date range as parameters.
Stu-Talk Monitor Summary (STMS): Specify a SMG, date range and it will give you an overview of the DOT, ...
... status) to output: Green (for Success), Red (for Fail), Orange (for Unknown).
Right-click on the rectangle and select Insert > Image
Edit the Image Properties to specify the image to use.
The ...
... 0)
-- Check whether value in B2 exists in range of A2:A100.
-- Returns the index of column A in which the B2 value was found.
-- Returns #N/A for a value which is NOT in column A.
Drag the formula ...
... to date range) and two use specified values (setup in the subscription section).
The report being subscribed to is hidden in tile view.
Cases where this would NOT work
Reports where the connection ...
... use the between-count interval operator to search for a number of occurrences within a specified range. For example, to find where 'a' occurs at least 3 times and no more than 5 times, you use the following ...
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.