Getting some insights from Jacoco html report
A simple script to count packages that contain classes with low coverage
Andrés Canavesi
-
Nov 29, 2021
After running the Jacoco report generator we can open it and see the coverage results. There are some results the I wanted to know, for example, how many packages contain uncovered classes and how many contain coverage under a given threshold
Invalid request provided: AWS::AppFlow::FlowCreate - Salesforce integration
This is a common error when a field is mapped in App Flow but it doesn't exist in Salesforce
Andrés Canavesi
-
Nov 19, 2021
Resource handler returned message: "Invalid request provided: AWS::AppFlow::FlowCreate Flow
Call an Apex method from Process Builder
See how to configure a Flow with process builder to execute an Apex method in Salesforce
Andrés Canavesi
-
Nov 11, 2021
As a thumb of rule in Salesforce you should always try to create new business logic through point-and-click but sometimes our logic it's a bit special and we need some Apex code.
AppFlow Salesforce: how to sync up relationships
An elegant solution to sync up relationships from Salesforce to AppFlow
Andrés Canavesi
-
Nov 10, 2021
Only basic types such as strings or numbers can be passed through AppFlow which means that look-up fields will be ignored. There's a way you can do it with some work from using the Salesforce out-of-the-box Process Builder tool, a custom object and some lines of Apex code.
flexsearch tutorial
We are going to build a small example to see how it works.
Andrés Canavesi
-
Nov 10, 2021
It's a module available through npm or yarn to index in-memory data.
With this module, you will be able to search or display related data on your site.
We are going to build a small example to see how it works.
Load dynamic data into a table using Lightning Web Component
Create a custom tab to display a Lightning Web Component
Andrés Canavesi
-
Nov 04, 2021
jsxBracketSameLine - Prettier how to configure
bracketSameLine is the new version of jsxBracketSameLine
Andrés Canavesi
-
Oct 29, 2021
Pro tip: instead of running by hand, you can integrate it with you favorite IDE
How to configure and use testcontainer in Node.js
testcontainer as a Node.js module to create dynamic containers
Andrés Canavesi
-
Oct 13, 2021
How to connect to a MySQL database in Node.js
Andrés Canavesi
-
Oct 12, 2021
To connect to a MySQL database in Node.js is pretty straightforward with the module mysql2.
Node.js Express Mysql stack deployed on Heroku
How to build a rest API from zero using Node.js, Express and MySQL
Andrés Canavesi
-
Oct 09, 2021
Let's build a Rest API from scratch that uses a MySQL database. We are going to use Node.js and Express as a framework to generate some scaffolding for our Rest API
Node.js and typescript project template
Andrés Canavesi
-
Oct 08, 2021
A project template with typescript, jest and linter among others configurations
This is most likely not an error with the salesforce cli
Please ensure all information is accurate and try again. (Salesforce)
Andrés Canavesi
-
Oct 07, 2021
Error authenticating with auth code due to: grant type not supported
Ubiquiti Unifi factory reset
How to reset unify from factory defaults
Andrés Canavesi
-
Sep 18, 2021
jsonplaceholder: a free fake API for testing and prototyping
JSONPlaceholder is a free online REST API that you can use whenever you need some fake data.
Andrés Canavesi
-
Sep 13, 2021
Prettier config
Prettier is a code formatter that supports many languages and can be integrated with most of the editors.
Andrés Canavesi
-
Sep 09, 2021
With Prettier you will be able to define your own rules, however default rules are enough at the beginning.
Sitemap xml creation
A sitemap is very important if you want to search engines discover and index your site properly.
Andrés Canavesi
-
Sep 09, 2021
No matter the language you are using in your site, this is the right way to create a sitemap.
Salesforce rest api download ContentVersion
Download a Salesforce file (ContentVersion) through the API using Node.js with jsforce package
Andrés Canavesi
-
Sep 09, 2021
flexsearch example
A super simple example to show how to index a collection of data and then run a full-text search
Andrés Canavesi
-
Sep 09, 2021
flexsearch It's an awesome package to index in-memory data
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server
mysql and knex
Andrés Canavesi
-
Sep 07, 2021
javascript lazy load images
javascript lazy load images
Andrés Canavesi
-
Aug 31, 2021
javascript lazy load images
redis delete all keys with prefix
redis delete all keys with prefix
Andrés Canavesi
-
Aug 31, 2021
redis delete all keys with prefix
error authenticating with auth code due to: grant type not supported
error authenticating with auth code due to: grant type not supported
Andrés Canavesi
-
Aug 31, 2021
error authenticating with auth code due to: grant type not supported
Salesforce integration with AWS AppFlow, S3, Lambda and SQS
Send data out of Salesforce with AWS AppFlow service in realtime
Andrés Canavesi
-
Aug 24, 2021
There are many ways to sync up our Salesforce data with third parties. One option is a mix of Salesforce and AWS services, specifically Change Data Capture from Salesforce and AppFlow from AWS.
Show failing tests after running a dry deployment (--checkonly) in Salesforce
Salesforce - SFDX CLI
Andrés Canavesi
-
Aug 24, 2021
Mock AWS SDK with Jest in TypeScript
An example mocking some SQS methods
Andrés Canavesi
-
Jul 31, 2021
It's a fact: you will spend some time writing mocks and slow down the development process but in the other hand unit test will run faster with less configuration.
Implement a wait sync with a promise in TypeScript
Delay a sync execution code
Andrés Canavesi
-
Jul 30, 2021
How to trigger a Lambda Function from S3
Notify a Lambda Function when creating a new file in an S3 bucket
Andrés Canavesi
-
Jun 20, 2021
Using Cloudformation to declare a Lambda Function and an S3 bucket
Magic Mover for Notes And Attachments to Lightning Experience
Get ready for Lightning Experience by migrating your attachments and notes
Andrés Canavesi
-
May 22, 2021
Files are more versatile and provide better functionality than attachments. Attachments can only be
attached to a single record, while files...
How to create files in Salesforce for testing purposes
ContentVersion and ContentDocumentLink creation from Apex
Andrés Canavesi
-
May 21, 2021
Fortunately, dealing with files in Salesforce in a unit text context, is pretty easy.
How to make Load and Smoke testing with Artillery
Artillery is a CLI tool installed easily through npm
Andrés Canavesi
-
May 20, 2021
Artillery is a modern load testing and smoke testing solution designed for cross-functional teams that run microservice-based systems on AWS and rely on CI/CD to ship at high velocity
How to render HTML in Jade
Jade is a Node.js template engine that uses indentation as part of the syntax
Andrés Canavesi
-
May 15, 2021
By default, Jade buffers the output so we have to be explicit when we want unbuffered code
Download and save a file in Node.js
Get a file from a server and store it in your disk
Andrés Canavesi
-
May 13, 2021
Download a file in Node.js is pretty straightforward. We are going to make an implementation using native modules. No third parties.
How to write to S3 bucket from Lambda function
AWS SAM template to create a Lambda function and an S3 bucket. Cloudformation world
Andrés Canavesi
-
May 12, 2021
Let's create a SAM template to declare a Lambda function to write into an S3 bucket
How to trigger a Lambda with a SQS message
AWS SAM template to execute a Lambda Function by writing a message in a SQS queue. Cloudformation world
Andrés Canavesi
-
May 12, 2021
Let's create a SAM template to declare a Lambda function to be triggered from an SQS message
How to publish a message in SQS from SNS
Creating a AWS CloudFormation template to publish to a topic and send it to Amazon SQS queues
Andrés Canavesi
-
May 10, 2021
A CloudFormation template example about how to create an SNS topic to publish a message in SQS in the AWS wolrd
Protect your social networks with two-factor authentication
See how to protect the most used social networks
Andrés Canavesi
-
Apr 29, 2021
Nowadays a super complex password is not enough to avoid being hacked. In fact, most of the times your password is not guessed by brutal force (try until it works).
SFDX - Error authenticating with auth code due to: grant type not supported
Common error when authenticating from SFDX CLI
Andrés Canavesi
-
Apr 27, 2021
Error authenticating with auth code due to: grant typw not supported.
This is most likely not an error with the Salesforce CLI. Please ensure all information is accurate and try again
How to setup Github Actions workflow lint
Configure a workflow to execute your linter when pushing code
Andrés Canavesi
-
Apr 25, 2021
How to setup Github Actions workflow lint
How to download a Salesforce file from Node.js
A JavaScript snippet to download a Salesforce file using the Rest API
Andrés Canavesi
-
Apr 20, 2021
Download a file from Salesforce using Node.js
How to download a file from Salesforce using Java Rest API
A Java snippet to download a Salesforce file through the Rest API
Andrés Canavesi
-
Apr 20, 2021
Let say we want to download a file stored in Salesforce. We'll have to deal with ContentVersion
Detect record changes in a Lightning Component
Listen to events when a record changes outside your Lightning component
Andrés Canavesi
-
Apr 16, 2021
Listening to changes in a Lightning Component from record changes
Download Salesforce metadata using SFDX
How to download Salesforce metadata to your local machine using SFDX CLI
Andrés Canavesi
-
Feb 23, 2021
Download Salesforce metadata using SFDX
Salesforce - Mock callouts in Apex
How to use mockups to tests callouts in Apex
Andrés Canavesi
-
Feb 19, 2021
Tests callouts in Apex
DB schema updates with knex in Node.js
Run database migration with knex
Andrés Canavesi
-
Feb 06, 2021
Knex is a query builder and among other things, it's an awesome tool to run DB migrations to create tables and modify them as you usually do with SQL scripts
How to send a message to AWS SQS queue from Salesforce Apex class
Surprisingly, making a callout to put a message in AWS SQS queue is tricky in Apex
Andrés Canavesi
-
Jan 31, 2021
How to post a message in an AWS SQS queue from an Apex class in Salesforce
Mock Axios with Jest
Mock request made by Axios using Jest in Node.js. Unit tests more unit
Andrés Canavesi
-
Jan 31, 2021
Mock Axios with Jest using successful and error response
P2: the collaboration tool from WordPress
"Fewer emails. More progress." it's a good argument to test it.
Andrés Canavesi
-
Sep 02, 2020
As communication moves increasingly online, staying organized can be a challenge. The way we work at WordPress.com is unique.
Mysql full text search (search related data)
Search related data in MySQL easily using Match and Against
Andrés Canavesi
-
Sep 01, 2020
Search related data in Mysql it's pretty easy
Dealing with concurrency in Node.js
Yeap, race condition is present also in Node.js regardless the single thread Event Loop
Andrés Canavesi
-
Aug 30, 2020
Even though the Event Loop is a single thread we have to take care of race condition since 99% of our code will run in a non main thread.
How to use a GitHub repository as a dependency in Node.js
Andrés Canavesi
-
Aug 30, 2020
Sometimes you need a dependency that is not published as a regular package at npmjs.com
Do you really need a mobile app?
Andrés Canavesi
-
Aug 30, 2020
I see lots of brands advertising "Hey, download our mobile app and…"
How to add a pie chart in Campaign’s record page in Salesforce
Add a cool chart in a record page easily. No code.
Andrés Canavesi
-
Aug 30, 2020
What about if we add a component with a pie chart on the Campaign object’s record page?
Dealing with customers
Give feedback, provide updates. Put in your customer's shoes
Andrés Canavesi
-
Aug 30, 2020
A post wrote by Jozsef Torsan that I would like to share here.
Salesforce client for an Apex RESTful web service
Expose a Rest service from an Apex class using RestResource annotation
Andrés Canavesi
-
Aug 29, 2020
An example about how to consume a Salesforce api rest
Define environment variables in Tomcat
Andrés Canavesi
-
Aug 29, 2020
Sometimes you want to change the behavior of your code without recompiling or deploying.
Detect if a string is a number with regex
Andrés Canavesi
-
Aug 28, 2020
How to know if a string is a number in JavaScript using a regular expression
Clean up more than two spaces and new lines with regex
A simple JavaScript method that removes all newlines and multiple spaces from a given text
Andrés Canavesi
-
Aug 28, 2020
A simple JavaScript method that removes all new lines and multiple spaces (including tab spaces) by a single space
Improve pg-promise stack traces
Andrés Canavesi
-
Aug 27, 2020
When you execute a query with error, we get a pg-promise internal module-specific stack trace.
How to use node-cache to accelerate queries
Using node-cache package to cache heavy and frequent queries in Node.js
Andrés Canavesi
-
Aug 25, 2020
Database access is usually expensive so you should optimize roundtrips as much as possible.
Search columns in Postgres
Andrés Canavesi
-
Aug 25, 2020
A simple query to search columns in different schemas
pg-promise self signed certificate error in Postgres
To fix this issue you have to use the package with the following recommendations
Andrés Canavesi
-
Aug 20, 2020
If you are using Node.js with some of these packages: pg-promise or pg probably you are facing this issue.
Install Postgres locally in MacOS
Install using Brew package manager
Andrés Canavesi
-
Aug 18, 2020
How to install Postgres database in your MacOS local machine
Install and run Redis locally
How to configure Redis to run it in your local machine.
Andrés Canavesi
-
Aug 18, 2020
How to install and run Redis in your local machine
Load stylesheets in background to increase page speed
Andrés Canavesi
-
Aug 16, 2020
Optimize the page loading time by loading your style sheets in background.
Lazy load images with javascript
Increase page loading time by requesting your images in background
Andrés Canavesi
-
Aug 12, 2020
Why should you load your images in a lazy way?
5 reasons to host your images on Cloudinary
Images and videos are everywhere. Leverage Cloudinary to manage them easily
Andrés Canavesi
-
Aug 12, 2020
Image and video management are present in almost all of our projects. I would like to share my experience with this.
How to connect to a Redshift database from Node.js
See how to use pg-promise to connect to a AWS Redshift database
Andrés Canavesi
-
Aug 11, 2020
A util piece of code to connect to a Redshift database
Bye bye FindBugs. Hello SpotBugs
Even FindBugs is no longer maintained we have an alternative called SpotBugs.
Andrés Canavesi
-
Aug 08, 2020
I used to use FindBugs plugin in my Java projects to detect and learn about issues and potential issues in my source code.
Cache implementation in Node.js
A custom cache implementation to show how Promises powerful are
Andrés Canavesi
-
Aug 08, 2020
A cached value it’s dynamic data, expensive to calculate, that we make it constant during a period of time.
Get Visualforce usage stats from VisualforceAccessMetrics
How to find out how often your Visualforce pages are accessed using Visualforce Access Metrics
Andrés Canavesi
-
Aug 08, 2020
If you want to know how frequently your Visualforce pages are accessed, you just have to run a simple query on VisualforceAccessMetrics
How to build a sitemap
A sitemap is very important if you want to search engines discover and index your site properly.
Andrés Canavesi
-
Aug 08, 2020
A sitemap is very important if you want to search engines discover and index your site properly.
Configure Prettier in your Node JS project
How to configure Prettier to format your code as It was written by only one developer
Andrés Canavesi
-
Aug 08, 2020
Prettier is a code formatter that supports many languages and can be integrated with most of the editors
Delete all keys by a prefix in Redis cluster
Reset a cache implemented in Redis for some specific keys with a prefix
Andrés Canavesi
-
Aug 04, 2020
Delete all the keys by a given prefix in a Redis cluster.
How to configure http auth basic in Node js and Express
Andrés Canavesi
-
Aug 04, 2020
Let’s build a small site in Node.js using Express that will have one protected page
Full-text search in Node JS - search related data
Search related content using FlexSearch package for Node.js. See an implementation example with Express framewrok
Andrés Canavesi
-
Aug 04, 2020
If you are building a website, e-commerce, a blog, etc., you will need a full-text search to find related content like Google does for every web page.
Better Queue in Node JS
Move heavy processing task to background with better-queue module in Node.js
Andrés Canavesi
-
Aug 03, 2020
A good practice in software development is to delegate as much heavy work as possible to background jobs to avoid blocking the main execution of your application that can be a web app, mobile app, or desktop.
Optimizing Node JS code
Small actions that may generate big impact in your performance
Andrés Canavesi
-
Aug 03, 2020
At different levels you might optimize your JavaScript code. Sometimes optimization is a matter of good practices such as avoid using logging in loops.
Customize styles highlight.js
Use your own styles to highlight source code
Andrés Canavesi
-
Aug 02, 2020
Customize styles highlight.js
Hash text in Node.js
Hash a text using native crypto module in Node JS. No extra dependencies.
Andrés Canavesi
-
Aug 02, 2020
Hash a string in Node.js without extra dependencies
5 reasons to choose WordPress as your content management tool
Popularity. Flexibility. SEO. Free and paid plans. Awesome editor
Andrés Canavesi
-
Jul 31, 2020
As Engineer I installed WordPress many times, facing issues such as performance and security. When you host WordPress by your own...
Template of Java web and Heroku
Andrés Canavesi
-
Jul 31, 2020
I’ve worked in several projects with Java, specially Java web using Tomcat as a web container and then Glassfish as application server.
Why I adopted Heroku
Heroku is a platform as a service (PaaS) acquired by Salesforce in 2011
Andrés Canavesi
-
Jul 31, 2020
Heroku is a platform as a service (PaaS)
Upload big files to S3 using Node.js
Stream big files from disk and upload them to AWS S3 bucket using chunks
Andrés Canavesi
-
Jul 29, 2020
Sometimes you need to upload a big file, let say bigger than 100MB. Stream from disk must be the approach to avoid loading the entire file into memory.
How to connect to a PostgreSQL database in Node.js
Connect to Postgres database in Node js using pg and parse-database-url packages
Andrés Canavesi
-
Jul 28, 2020
A simple example about how to connect to a PostgreSQL database using Node.js
Compress a file in Node.js
Andrés Canavesi
-
Jul 27, 2020
Zip a file in Node.js it's easy using zlib
How to configure HTTPS in Node.js
See how to setup a secure environment in our local machine to test HTTPS
Andrés Canavesi
-
Jul 27, 2020
Sometimes we need to configure a secure environment locally to test how our application reacts to HTTPS.
Test Driven Development (TDD) in a nutshell
Andrés Canavesi
-
Jul 24, 2020
Every project has somewhere in the src folder a file called utils.js, Utils.java, utils.py, etc....
Migrate sforce.connection.query to Lightning equivalent
Use Lightning Components to move your JavaScript buttons implemented for Classic
Andrés Canavesi
-
Jun 18, 2020
As you probably know, JavaScript buttons are not supported in Lightning Experience (LEX). In particular, you can’t use REQUIRESCRIPT.
In this post, the idea is to show how to migrate a particular JavaScript button that uses sforce.connection.query sentence.
How to convert sforce.apex.execute to Lightning
Use a Lightning Component to make your JavaScript buttons work when your move to Lightning Experience
Andrés Canavesi
-
Jun 18, 2020
Let’s see how to convert a Salesforce JavaScript button that uses sforce.apex.execute in to Lightning Experience.
The good news is you will reuse this code and the approach for all your similar buttons.
Migrate $User, $Profile, $Label and $Api to Lightning Components
Rollout to Lightning by migrating non-supported JavaScript buttons
Andrés Canavesi
-
Jun 18, 2020
We can’t use $User, $Profile, $Label and $Api in Lightning. We need to implement a server-side solution.
How to build a sitemap xml in Node js using Express
Create a sitemap in Node and Express framework for Search Engine Optimization
Andrés Canavesi
-
Jun 17, 2020
A good sitemap.xml will help you a lot in terms of SEO. It’s a nice starting point if you want to index your site. It’s just a standard XML file that search engines understand.
Redirect all requests from HTTP to HTTPS in Node.js and Express
How to redirect all non secure requests to HTTPS in Node.js and Express
Andrés Canavesi
-
Jun 15, 2020
The first step will be to create a method to guess if the HTTP request comes from HTTP or HTTPS (secure or not secure). In some context like AWS or Heroku you will have to ask by the header x-forwarded-proto instead of req.secure.
