google apps script - Invalid Argument on basic API call using UrlFetchApp.fetch(url) -

-

i'm new google apps scripts , i've been trying make simple call url. make call browser: https://accounting.sageone.co.za/api/1.1.1/supplier/get?apikey={4cfeefe1-ce04-425f-82c3-dcb179c817d5}&companyid=164740 , respons i'm looking for. try make call google apps scripts using following code:

function myfunction() { var url = 'https://accounting.sageone.co.za/api/1.1.1/supplier/get?apikey={4cfeefe1-ce04-425f-82c3-dcb179c817d5}&companyid=164740 var response = urlfetchapp.fetch(url); logger.log(response); }'

i respons stating ' message details invalid argument: https://accounting.sageone.co.za/api/1.1.1/supplier/get?apikey={4cfeefe1-ce04-425f-82c3-dcb179c817d5}&companyid=164740 (line 4, file "code")'

i've tried whole bunch of permutations no luck...

when using urlfetchapp, need enter url parameters part of request parameters rather in url itself. get request these go directy part of parameters, post request parameters part of payload object. reference documentation

here modified function:

function myfunction() {   var url = 'https://accounting.sageone.co.za/api/1.1.1/supplier/get'     var params = {     "method": 'get',     "apikey": "{4cfeefe1-ce04-425f-82c3-dcb179c817d5}",     "companyid": "164740"   }   var response = urlfetchapp.fetch(url, params);   logger.log(response) }

note: corrects method, however, server still requires further authentication. if run issues that, ask questions specific issue well.


Comments

Post a Comment

Popular posts from this blog

Load Balancing in Bluemix using custom domain and DNS SRV records -

-
i'm trying load balancing of application in bluemix using custom domain , srv record in dns manager. created own doamin ccbluemix.dynu.com , added custom domain bluemix. created application in region , created route custom domain myapp.ccbluemix.dynu.com deployed same application in uk region , created route custom domain myapp.ccbluemix.dynu.com there well. now whenever user hits route want load balancing between , uk region alternate requests served , uk regions. for created srv records like _http._tcp.ccbluemix.dynu.com srv eu-gb.mybluemix.net [priority: 0] [weight: 50] 10 _http._tcp.ccbluemix.dynu.com srv mybluemix.net [priority: 0] [weight: 50] 10 but nothing happening , i'm not able access application using custom route @ all. if create 'a' record cc-load-bal-app.ccbluemix.dynu.com 75.126.81.68 i can access app using custom route ends hitting server. how can achieve load balancing using srv records? wrong creating srv records here? i read ne...
Read more

oracle - pls-00402 alias required in select list of cursor to avoid duplicate column names -

-
my cursor : select xzis.msisdn msisdn, xzis.in_account_number in_account_number xxobw_zte_in_sync xzis not exists (select 1 hz_contact_points hcp, hz_cust_accounts hca hcp.owner_table_id = hca.party_id , hcp.owner_table_name = 'hz_parties' , hcp.phone_number = substr (xzis.msisdn, -8) , nvl (hca.attribute12, 'nil') = xzis.in_account_number); i have given alias columns, still facing issue. suggestions? it's cursor. 1 has no such problems. problem is, when you're joining 2 tables, or apply wrong aliases in subselect, cursor may @ end return 2 columns same name/alias. the problem not need alias, no 2 columns can have same alias (the name counting alias, when no alias given). apparently has happened, far can tell, it's ...
Read more

python - Apache Thrift Tutorial Error -

-
i've been trying learn use apache thrift in python following tutorial: http://www.billdimmick.com/devjournal/building-an-apache-thrift-service-in-python.html . thrift file used tutorial is: namespace py demo service mathservice { i64 add(1: i64 a, 2: i64 y) } when try compile python code thrift --gen py:new_style demo.thrift following error: [error:/home/pi/programming/python/thrift-tutorial/demo.thrift:4] (last token '{') syntax error [failure:/home/pi/programming/python/thrift-tutorial/demo.thrift:4] parser error during include pass i can't see wrong thrift file i'm still getting errors. what's wrong?
Read more