dubeyji10

import requests
import json
'''

  {{accounts-domain}}/crm/v2/{{custom-module-name}}
  in this case conversation

'''
url = "https://www.zohoapis.in/crm/v2/conversation"

dubeyji10

import requests
import json

'''
  
    -> {{custom-module-name-2}} corressponds to invoice_info in postman client
    dummy data insert into new custom module named invoice info
    this is an auto increment field on invoice id

'''

dubeyji10

import requests
import json

'''

    in this payload has a created by field in json with neccessary fields
    so creation is done by that user

      "Created_By": {
        "name": "your-user-name",

dubeyji10

import requests
import json

url = "https://www.zohoapis.in/crm/v2/invoice_items"

payload = json.dumps({
  "data": [
    {
      "Name": "00000000000000000003",
      "Total_Months": 2,

dubeyji10

 {
   "id": 14,
   "contact_person1": "Ajay Laddha",
   "contact_person2": "",
   "company_name": "Neha Collection",
   "company_grade": "D",
   "phone_no": null,
   "mobile_no1": "7567369544",
   "mobile_no2": null,
   "email": "[email protected]",

dubeyji10

dubeyji10

/* example of clients table */

/* without use of json_object */

SELECT table2.* FROM (      SELECT 'Name', 'added_on', 'phone_no', 'local_id' , 'Email', 'clients_user_id'       UNION ALL     ( select company_name as Name,CONCAT(replace(DATE_FORMAT(added_on,'%Y-%m-%d %T'),' ','T'),"+05:30") as added_on,(select case when ifnull(phone_no,'') <> 0 then phone_no  else '' end) as phone_no,id as local_id,email as Email,user_id as clients_user_id from clients     ) ) table2;
 
set @json_file2 = (
    select group_concat(table1.data1, table1.data2 ) from
    (
      select concat('{"','clients_user_id','"',':','"',user_id,'",') as data1 ,concat('"','Name','"',':','"',company_name,'"}',char(10)) as data2 from clients

dubeyji10

/* 

create a test db 
use that db 
to test and export sql dump

*/

/* create a table clients */
CREATE TABLE clients (

dubeyji10

ALTER TABLE invoice_info CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

/* errors - - - - address field not validated */

set @json_ob_8 = (
    select REGEXP_REPLACE( 
        GROUP_CONCAT(json_object (
             'Name',CAST(id as CHAR),
             'Address' ,Address,
             'Email' ,Email ,

dubeyji10

/* leads charset fixation */
ALTER TABLE leads CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
/* create a view to write out table of requirement*/

/* -------------------------------------------------- */
CREATE VIEW `leadsJsonView_2` AS
select
  concat(
    '{',
    '"',