Email needs to be array but not working (Google Script)

janp at August 14th, 2020 09:05 — #1

Hi,

I am trying to do a POST request to make a new contact. Emails need to be an array which it now is after some tweeking but the content is not going to the CRM. I am working in Google Script. See below. Any ideas?

var url = 'https://app.onepagecrm.com/api/v3/contacts';
var res = UrlFetchApp.fetch(url, {
  method: 'post',
  headers: { 
    'accept': 'application/json',
    'Authorization': 'Basic ' + Utilities.base64Encode(user_id + ':' + api_key)
  },
  payload: {
    "last_name": name,
    "emails" : ["type : work"]["value : "+email]
          },
  muteHttpExceptions: true
});

vladimir at August 17th, 2020 07:34 — #2

Hi JanP!

Our API accepts an array of hashes for emails field. Please try the following script:

var url = 'https://app.onepagecrm.com/api/v3/contacts';
var res = UrlFetchApp.fetch(url, {
  method: 'post',
  headers: { 
    'accept': 'application/json',
    'Authorization': 'Basic ' + Utilities.base64Encode(user_id + ':' + api_key)
  },
  payload: {
    "last_name": name,
    "emails": [{"type": "work", "value": + email}, { "type": "home", "value": "other@email.com"}]
  },
  muteHttpExceptions: true
});

Please don't hesitate to contact us if you have more questions

Vladimir

janp at August 17th, 2020 08:28 — #3

Hi Vladimir, the error has not been fixed and still the same.

In this way it does work but the I can't add the email:
function addContact(name, email) {
var url = 'https://app.onepagecrm.com/api/v3/contacts';
var res = UrlFetchApp.fetch(url, {
method: 'post',
headers: {
'accept': 'application/json',
'Authorization': 'Basic ' + Utilities.base64Encode(user_id + ':' + api_key)
},
payload: {
"last_name": "test",
"emails": ["test"]["test"]
},
muteHttpExceptions: true
});

vladimir at August 17th, 2020 09:15 — #4

Hi JanP!

Here's my attempt to create a contact on my local server:

curl --header "Content-Type: application/json" \
  --header "Authorization: Basic #{somedata}" \
  --request POST \
  --data '{"last_name":"test","emails":[{"type": "work", "value": "my@email.com"}]}' \
  http://localhost:3000/api/v3/contacts.json


{"status":0,"message":"Created","timestamp":1597669883,"data":{"contact":{"id":"5f3a81f8849d78ab2a98f90d","first_name":"","last_name":"test","job_title":"",
...
phones":[],"emails":[{"type":"work","value":"my@email.com"}],
"sales_closed_for":[],"closed_sales":[],"created_at":"2020-08-17T13:11:20Z","modified_at":"2020-08-17T13:11:20Z"},
...
}%

Please check you're sending valid content type header and valid request body as in my example. Emails field is an array of hashes of type: {type: 'work|home|other', value: 'some@email.com'}Also please provide us the response (or maybe error message) that comes from server for your request. Your code snippet looks valid at the first glance, so maybe the problem in your case is with authentication or something else.

Vladimir

janp at August 17th, 2020 09:34 — #5

Hi Vladimir,

This is the reply with your code:

{"status":400,"message":"Invalid request data","error_name":"invalid_request_data","error_message":"A validation error has occurred","errors":{"emails":"Must be an array"}}

This is the reply when I have "emails": ["test"]["test"] in my code:

{"status":0,"message":"Created","timestamp":1597671701,"data":{"contact":{"id":"5f3a8915cf5a4e7e0eb7b28a","first_name":"","last_name":"jan Test","job_title":"","company_id":"","company_name":"","company_size":0,"owner_id":"57f4cd1c00d4af193696a3cc","status":"High Turnover","status_id":"57f4cd3500d4af2a4596a20f","tags":[],"starred":false,"background":"","lead_source_id":"","pending_deal":false,"total_pendings":0.0,"total_deals_count":0,"photo_url":"","custom_fields":[],"address_list":[{"address":"","city":"","state":"","zip_code":"","country_code":"","type":""},{"address":"","city":"","state":"","zip_code":"","country_code":"","type":""}],"google_contacts_data":null,"letter":"j","urls":[],"phones":[],"emails":[],"sales_closed_for":[],"closed_sales":[],"created_at":"2020-08-17T13:41:41Z","modified_at":"2020-08-17T13:41:41Z"},"next_actions":[],"next_action":{},"queued_actions":[],"next_action_conflicts":[]},"lead_sources":[{"id":"advertisement","text":"-","counts":0,"total_count":0,"action_stream_count":0,"team_counts":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":0}]}],"statuses":[{"status":{"id":"57f4cd3500d4af2a4596a20f","status":"lead","text":"High Turnover","description":"Festival Organisation","color":"db2b5d","counts":172,"total_count":172,"action_stream_count":172,"team_counts":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":173}]}},{"status":{"id":"5da5ca7e9b79b278c639af5a","status":"custom28","text":"Medium Turnover","description":"Description","color":"f96600","counts":138,"total_count":138,"action_stream_count":138,"team_counts":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":138}]}},{"status":{"id":"5da5ca7e9b79b278c639af5b","status":"custom29","text":"Low Turnover","description":"Description","color":"3399ff","counts":1396,"total_count":1396,"action_stream_count":1396,"team_counts":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":1396}]}},{"status":{"id":"5e957417ccd15a7cd83811b2","status":"custom33","text":"Priorty 1 - Corona","description":"Description","color":"f96600","counts":11,"total_count":11,"action_stream_count":11,"team_counts":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":11}]}},{"status":{"id":"5da5cdb09b79b21f9139a3e2","status":"custom32","text":"Closed","description":"Description","color":"009900","counts":2617,"total_count":2617,"action_stream_count":2617,"team_counts":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":2617}]}}],"tags":{"tags":[{"name":"2020","counts":79,"total_count":79,"action_stream_count":79},{"name":"ABC","counts":237,"total_count":237,"action_stream_count":237},{"name":"ABC-Jan","counts":536,"total_count":536,"action_stream_count":536},{"name":"ABC-November","counts":46,"total_count":46,"action_stream_count":46},{"name":"ABC-November-Jan","counts":38,"total_count":38,"action_stream_count":38},{"name":"Bed\u0026Smile","counts":45,"total_count":45,"action_stream_count":45},{"name":"Camplight","counts":3,"total_count":3,"action_stream_count":3},{"name":"DancinDaves","counts":8,"total_count":8,"action_stream_count":8},{"name":"DomoCamping","counts":2,"total_count":2,"action_stream_count":2},{"name":"FatFranks","counts":4,"total_count":4,"action_stream_count":4},{"name":"FelixUnite","counts":3,"total_count":3,"action_stream_count":3},{"name":"FestiTent","counts":3,"total_count":3,"action_stream_count":3},{"name":"FreeSpiritCampers","counts":8,"total_count":8,"action_stream_count":8},{"name":"Green Camp","counts":5,"total_count":5,"action_stream_count":5},{"name":"HarambeeHotel","counts":3,"total_count":3,"action_stream_count":3},{"name":"Interested","counts":2,"total_count":2,"action_stream_count":2},{"name":"Jan","counts":2546,"total_count":2546,"action_stream_count":2546},{"name":"kerst2019","counts":26,"total_count":26,"action_stream_count":26},{"name":"Larp","counts":30,"total_count":30,"action_stream_count":30},{"name":"money","counts":1,"total_count":1,"action_stream_count":1},{"name":"Mooggee","counts":5,"total_count":5,"action_stream_count":5},{"name":"MZSS","counts":27,"total_count":27,"action_stream_count":27},{"name":"PamperTheCamper","counts":4,"total_count":4,"action_stream_count":4},{"name":"PitchVillage","counts":7,"total_count":7,"action_stream_count":7},{"name":"Podpads","counts":13,"total_count":13,"action_stream_count":13},{"name":"Project Shelter","counts":26,"total_count":26,"action_stream_count":26},{"name":"Psy-Ventures","counts":6,"total_count":6,"action_stream_count":6},{"name":"PsycloneTents","counts":5,"total_count":5,"action_stream_count":5},{"name":"RentATent","counts":18,"total_count":18,"action_stream_count":18},{"name":"RushAdventures","counts":9,"total_count":9,"action_stream_count":9},{"name":"ShowSherpa","counts":6,"total_count":6,"action_stream_count":6},{"name":"SimplePleasures","counts":5,"total_count":5,"action_stream_count":5},{"name":"Sleep-Em-All (PT)","counts":13,"total_count":13,"action_stream_count":13},{"name":"Sofie","counts":1310,"total_count":1310,"action_stream_count":1310},{"name":"Tangerinefields","counts":15,"total_count":15,"action_stream_count":15},{"name":"TentCity","counts":9,"total_count":9,"action_stream_count":9},{"name":"The Nomad (PT)","counts":3,"total_count":3,"action_stream_count":3},{"name":"TheGarden","counts":3,"total_count":3,"action_stream_count":3},{"name":"ThePopUpHotel","counts":13,"total_count":13,"action_stream_count":13},{"name":"Timo","counts":16,"total_count":16,"action_stream_count":16},{"name":"TOICamp","counts":4,"total_count":4,"action_stream_count":4},{"name":"UnderSky","counts":7,"total_count":7,"action_stream_count":7},{"name":"UtopiaCamping","counts":10,"total_count":10,"action_stream_count":10},{"name":"WOWTents","counts":6,"total_count":6,"action_stream_count":6},{"name":"YippeeTents","counts":4,"total_count":4,"action_stream_count":4}],"system_tags":[{"name":"starred","counts":3,"total_count":3,"action_stream_count":3}]},"contacts_count":{"all":{"1":43,"a":216,"b":386,"c":280,"d":245,"e":154,"f":202,"g":167,"h":192,"i":72,"j":109,"k":152,"l":235,"m":275,"n":96,"o":96,"p":183,"q":8,"r":188,"s":367,"t":178,"u":32,"v":232,"w":160,"x":7,"y":24,"z":35,"total_count":4334},"users":[{"1":43,"a":216,"b":386,"c":280,"d":245,"e":154,"f":202,"g":167,"h":192,"i":72,"j":110,"k":152,"l":235,"m":275,"n":96,"o":96,"p":183,"q":8,"r":188,"s":367,"t":178,"u":32,"v":232,"w":160,"x":7,"y":24,"z":35,"total_count":4335,"user_id":"57f4cd1c00d4af193696a3cc"}]},"team_stream":{"users":[{"user_id":"57f4cd1c00d4af193696a3cc","counts":4335}],"all":4335}}

janp at August 17th, 2020 09:34 — #6

So there is no problem with the authentication.

vladimir at August 17th, 2020 11:53 — #7

JanP according to the error returned it looks like you're missing the [] brackets, so you're sending something like

"emails": { "type": "work", "value": email }

Please make sure you provide an array like the following:

"emails": [{ "type": "work", "value": email }]

Vladimir

janp at August 18th, 2020 03:02 — #8

Hi Vladimir,

Still no change:

   var url = 'https://app.onepagecrm.com/api/v3/contacts';
  var res = UrlFetchApp.fetch(url, {
      method: 'post',
      headers: { 
        'accept': 'application/json',
        'Authorization': 'Basic ' + Utilities.base64Encode(user_id + ':' + api_key)
      },
      payload: {
        "last_name": name,
        "emails": [{ "type": "work", "value": "test@test.com" }]
      },
      muteHttpExceptions: true
    });

And the reply:

{"status":400,"message":"Invalid request data","error_name":"invalid_request_data","error_message":"A validation error has occurred","errors":{"emails":"Must be an array"}}

vladimir at August 19th, 2020 14:06 — #9

Hi JanP!

I finally understood what you're doing wrong: it's the call to UrlFetchApp.fetch and you should specify json format in URL. I've read documentation for UrlFetchApp class and learned how to send JSON requests. Here I wrote the corrected script which works:

var url = 'https://app.onepagecrm.com/api/v3/contacts.json';
var payload = {
  "last_name": "OnePageCRM API test",
  "emails": [{"type": "work", "value": "mytest@email.com"}]
};
var res = UrlFetchApp.fetch(url, {
  method: 'post',
  contentType: 'application/json',
  headers: { 'Authorization': 'Basic ' + Utilities.base64Encode(user_id + ':' + api_key) },
  payload: JSON.stringify(payload),
  muteHttpExceptions: true
});

Please try it, it works for me

Vladimir

janp at August 19th, 2020 15:57 — #10

This worked! I tried it too but I see I forgot to add contentType: application/json.

Thanks a million!