Assuming connector is required, the following 19 results were found.
-
Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
function requires as parameters according to documentation = zoho.bookings.getAvailableSlots(, , , ); Set up your connector with the following scope: zohobookings.data.CREATE Get the workspaces: // // get workspaces r_WorkspaceResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth Give your connection a name, I'm calling mine "Joels Connector" Select the Scopes: ZohoWriter.documentEditor.ALL and ZohoWriter.Merge.ALL For good measure, I'm going to include the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
all the applicable fields from the settings API. In API v2, you have to do it this way apparently. So setup a Zoho Oauth connector (see the end of this article if you don't know how), I'm going to call mine myZohoConnector, with the scope:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
> Setup > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): 2. Code to push Time Log entry to Zoho Projects:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
is how I did it, I found the process rather straightforward anyway so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
support is deprecated","status":"error"}: Happens when using a CRM connector of type "Zoho". Another type of connector for v2 is called "Zoho OAuth". Re-create the connectors with the latter: r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection: "joelconnector" ]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter: First...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
client machine. Download and install the MySQL ODBC driver (at time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your system Install it Setup the ODBC Connection Start > Programs...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
fields: Store/save your DOR Setting up the DataEvent-Out-Tray Rule (EOR) Here we enter the SQL command (if using SQL db connector) which will output the data to a MSSQL database. Run EOR from the menu system Enter a EOR code (for everyone's sanity, name...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
an issue where I was trying to push a Zoho Creator record into Zoho Inventory via an invokeURL with API v2 rather than a connector. If you use POST then this adds/creates a record and if it already exists you will get a {"code":1001,"message":"Item...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
connection with scope (ZohoCRM.modules.ALL) r_DownloadFile = invokeurl [ url :v_CrmEndpointUrl type :GET connection:"my_connector" ]; // add record as zoho.loginuser so that only record owners can access this record in report or form r_HoldInCreator =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
[ url :"https://www.zohoapis.eu/crm/v2.1/Invoices/" + p_InvoiceID type :GET parameters: m_Params connection:"joels_connector" ]; info r_InvoiceDetails; Common Error(s): {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Zoho CRM record owner, looping through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The "v_Filter" appears to do absolutely nothing but I've left it in there in case one day...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
r_CreateRecord = zoho.creator.createRecord(v_AppOwner,v_AppName,v_FormName,m_CreateRecord,m_Blank,"joels_connector"); /* // Email yourself as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
your own) r_UpdateSO = invokeurl [ url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info r_UpdateSO; } } Source(s): Zoho Community Forums - Zoho Inventory - Error: Please ensure that the billing_address...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given it the following scopes: ZohoCRM.modules.ALL ZohoCRM.users.READ...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_Response = invokeurl [ url :v_Endpoint type :GET connection:"joels_connector" ]; if(!isnull(r_Response.get("fields"))) { // loop through every field to find the customer's timezone one for each r_Field in r_Response.get("fields") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *