What?
A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters.
How?
Let's first define a map:
m_Payload = Map();
m_Payload.put("client_id","my-unique-client-id");
m_Payload.put("redirect_uri","https://www.joellipman.com");
m_Payload.put("response_type","code");
m_Payload.put("scope","my_api_scopes");
m_Payload.put("prompt","login");
Great! ...
What?
I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...
Intro
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...
... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services.
The Error
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 114 ...
... number my bosses want - 7h 24m or 26640s is 1 person day)...
With date range as parameters
...ouch...
...and it was so easy up to here...
Tables of interest
StaffActivities
...
... of this article).
The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...
... specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date.
Solution
Easy for some but anything that I spend 30 minutes ...
... rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows
This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes ...
... 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query).
Problems:
Given a date, the date format ...
... of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week.
How?
As mentioned, using leftpad takes 2 parameters, ...
What?
This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...
... uploads 1 photo.
Error(s) Encountered
The endpoint is wrong (for example you don't need the organization ID parameter at the end of the URL)
The .setParamName() function is setting the data ...
... snippet for a Zoho Creator page. We set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how to embed using an IFRAME ...
... Name: fn_eBay_UploadPhoto
Display Name: Fn - eBay - Upload Photo
Description: What it says on the tin
Category: Standalone
Click on Create
Give it the parameter/argument p_InventoryitemID as ...
...
Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine:
// ****************** CODE USING ...
What?
This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter.
Why?
Mostly for debugging but here's the code that will quickly get the ...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... these into data for invoices and contacts.
Category: Standalone
Click on Create
Give it the parameter: crmAPIRequest (string)
Dump in the following code:
// enter the webhooks key for your app ...
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.