smallik123

[smallik123]

How to integrate Microsoft team from PHP application

cdata To integrate Microsoft Teams with a PHP application, you’ll need to use the Microsoft Graph API, which provides a unified programmability model for Microsoft services, including Teams. The Graph API allows you to access Teams data, such as channels, messages, and members, and perform actions, such as sending messages and creating meetings. Here are the general steps to integrate Microsoft…

[smallik123]

How to Create Custom API V8 in Suite CRM 8

Creating a custom API in SuiteCRM 8 involves a few steps. Here’s a high-level overview of the process: Define the API endpoint: Decide on the functionality you want to expose through your custom API. Determine the URL endpoint for your API, such as custom/application/Ext/Api/V8/. Create a new Custom API controller: In the SuiteCRM 8 source code, navigate to the…

[smallik123]

Python Script for Data Migration

Python Script for Data Migration

Migrate data from CSV to Postgres and Postgres to MySQL step by step:-

import pymysql, psycopg2, csv

# Postgres Connection properties postgres_connection = psycopg2.connect(user = “postgres”, password = “*****”, host = “127.0.0.1”, port = “5432”, database = “python_db”) postgres_cursor = postgres_connection.cursor() print (“Opened Postgres database successfully”) # MySQL Connection properties my…

[smallik123]

Salesforce Validation Rules

Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record. A validation rule can contain a formula or expression that evaluates the data in one or more fields and returns a value of “True” or “False”. Validation rules also include an error message to display to the user when the rule returns a value of “True” due to an…

[smallik123]

Salesforce Developer Interview Questions & Answers

Salesforce Developer Interview Questions & Answers

  1. Can you name three types of object relationships available in Salesforce?

A lookup relationship can be used to link two objects together. It is the most basic type of relationship that creates a child-parent relationship between two objects.

A master-detail relationship can also be used to link two objects together. A master-detail relationship creates a tight relationship between the parent…

[smallik123]

SFDC - Data Loader Command Line Introduction - Invoke Data Loader on window

SFDC – Data Loader Command Line Introduction – Invoke Data Loader on window

Step One: Create the Encryption Key File

Create an encryption key file by entering the following command. Replace [path to key file] with the key file path.

encrypt.bat —k [path to key file] – Note the key file path. In this example, the path is C:\Users\IEUser\.dataloader\dataLoader.key.

Step Two: Create the Encrypted Password

encrypt.bat –e <password> <key file path>

[smallik123]

How to calculate date difference in JavaScript?

How to calculate date difference in JavaScript?

var DateDiff = { inDays: function(d1, d2) { var t2 = d2.getTime(); var t1 = d1.getTime(); return parseInt((t2-t1)/(24*3600*1000)); }, inWeeks: function(d1, d2) { var t2 = d2.getTime(); var t1 = d1.getTime(); return parseInt((t2-t1)/(24*3600*1000*7)); }, inMonths: function(d1, d2) { var d1Y = d1.getFullYear(); var d2Y = d2.getFullYear(); var d1M = d1.getMonth(); var d2M = d2.getMonth(); return…

[smallik123]

at Bangalore, India https://www.instagram.com/p/BsP9mbLHQR6/?utm_source=ig_tumblr_share&igshid=mxb26mams5ql

[smallik123]

Difference Between - Keys in MySQL

Difference Between – Keys in MySQL

Primary key and Candidate key?

Primary key in MySQL is use to identify every row of a table in unique manner. For one table there is only one primary key. One of the candidate keys is the primary key and the candidate keys can be used to reference the foreign keys.

Primary key and Unique key?

While both are used to enforce uniqueness of the column defined but primary key would…

[smallik123]

MySQL Joins in Simple Word

MySQL Joins in Simple Word

In MySQL the Joins are used to query data from two or more tables. The query is made using relationship between certain columns existing in the table. There are four types of Joins in MySQL.

Inner Join

Inner Join returns the rows if there is at least one match in both the tables.

Left Join

Left Join returns all the rows form the left table even if there is no match in the right…

[smallik123]

Interfaces - object oriented programming

Interfaces – object oriented programming

Object interfaces allow you to create code which specifies which methods a class must implement, without having to define how these methods are implemented. Interfaces are defined in the same way as a class, but with the interface keyword replacing the class keyword and without any of the methods having their contents defined. All methods declared in an interface must be public; this is the…

[smallik123]

at Bangalore, India https://www.instagram.com/p/BoFOCiAhCDo/?utm_source=ig_tumblr_share&igshid=oujamnllpxsv

[smallik123]

at Bangalore, India

[smallik123]

Time for relax after stressful day. (at BTM Layout)

[smallik123]

Gym with my best buddy (at Infosys Campus Bangalore India)

[smallik123]

SugarCRM – SugarQuery – Raw Methods

groupByRaw()

To add multiple fields to the GROUP BY statement on the SugarQuery Object, it may be easiest to use the groupByRaw() method.

$SugarQuery = new SugarQuery(); $SugarQuery->select(array('account_type', 'industry')); $SugarQuery->from(BeanFactory::newBean('Accounts')); $SugarQuery->groupByRaw("accounts.account_type,accounts.industry");

orderByRaw()

Using the oderBy() method only allows…

[smallik123]

SugarCRM – SugarQuery - Advanced Techniques -

SugarCRM – SugarQuery – Advanced Techniques –

some of the advanced methods that SugarQuery has to offer, that are not as commonly used.

getOne()

//Get the Name of the account $accountName = $SugarQuery->getOne();

setCountQuery()

$SugarQuery->select(array('name'))->setCountQuery();

joinName()

$contacts = $SugarQuery->join('contacts')->joinName();

union()

//Create union $sqUnion = new SugarQuery(); $sqUnion->union($SugarQuery1);…