Integrating Shopify Private App with Netsuite

July 8, 2016 Adolfo Garza Comments 527 comments

I couldn’t find this in the shopify documentation so I thought it would be helpful to share it.

Backstory:
I was trying to get the JSON from Shopify Private App and I was getting this error:

[API] Invalid API key or access token (unrecognized login or wrong password)

After much research all I needed to do was add header “X-Shopify-Access-Token”.

Here’s the code, just make sure to replace HTTPSMODULE or load with the Netsuite https Module.

var SHOP_NAME = 'YOUR_SHOP_NAME';

var API_KEY = 'YOUR_API_KEY';

var PASSWORD_ACCESS_TOKEN = 'YOUR_PASSWORD_ACCESS_TOKEN';

var URLTEMPLATE = 'https://$APIKEY$:$PASSWORD$@$SHOP$.myshopify.com'

.replace('$SHOP$', SHOP_NAME)

.replace('$APIKEY$', API_KEY)

.replace('$PASSWORD$', PASSWORD_ACCESS_TOKEN);

function run(){

var myUrl = URLTEMPLATE;

var path = '/admin/orders.json';

myUrl += path;

var orders = shopifyRequest(myUrl);

var ordersJSON = JSON.parse(orders);

return orders;

}

function shopifyRequest(myurl){

var myrequest = {};

myrequest.url = myurl;

myrequest.method = HTTPSMODULE.Method.GET;

myrequest.headers = {};

myrequest.headers["X-Shopify-Access-Token"] = PASSWORD_ACCESS_TOKEN;

var myresponse = HTTPSMODULE.request(myrequest);

return myresponse.body;

}

Esau Grover Ocrospoma Callupe

Hi Adolfo, do you have tried to intregate Netsuite with mailchimp? I have some error in Script 1.0, i try to replicated in 2.0 but i have problems whith this function “http” or “https”. I need to do the similar like this code https://gist.github.com/vgelani/801b6f146dd4da05c4ae666480bd9ede this is PHP and i want to replicated in Netsuite, I need that when I save a customer, get the email, the name and the lastname, then i save a new member in a list in Mailchimp. In 1.0 use this headers var headers = [{“Authorization”:”Basic “+apiKey, “Content-Type” :”application/json}]; but I could not save creating a new member in Mailchimp. Please Help me.
- Adolfo Garza
  
  I have never integrated with Mailchimp, but it looks easy enough. Follow the https POST example on Netsuite’s documentation: https://imgur.com/a/NM2mH
  - Esau Grover Ocrospoma Callupe
    
    why do you use put?, in the case that I only want to create a new member. This is my code but I dont know what is the error, https://github.com/EsauOcrospomaCallupe/IntegracionesNS/blob/master/mailchimp_clnt.js I use this web page to guide https://medium.com/@dddotcom/intro-to-mailchimp-api-3-0-adding-members-to-a-mailing-list-and-testing-with-postman-f056d900e0d9
    - Adolfo Garza
      
      That gist you wanted replicated had a PUT request. I checked your code and looks like you are using clientscript which I would not recommend for this, use a userevent or scheduled script so the logic runs on the server instead and that way you keep your credentials safe. Also, you are mixing 2.0 code with 1.0 code, I can tell be because 2.0 functions no longer use nlapi. Stick to 2.0.
      - Esau Grover Ocrospoma Callupe
        
        The functions nlapi are commented. The error is in the function https, I use client script because i need to send to Mailchimp when i save the customer for example
      - Adolfo Garza
        
        I see, then change it to POST if that’s how Mailchimp works. You can use a user event – After Submit instead to send the data after the record is saved.
      - Esau Grover Ocrospoma Callupe
        
        https://github.com/EsauOcrospomaCallupe/IntegracionesNS/blob/master/mailchimp_ue.js I use a User Event script but https://uploads.disquscdn.com/images/7177ac7a8c5f57b2c97828cc49441dc5e93c7188a5dbead77c76092b99bb0926.jpg , I dont know if I am using the correct HEADERS, Netsuite Support call me and they told me that this conecction is only in Client Script.
      - Adolfo Garza
        
        I see. On that screenshot it says that the error is caused because the API Key is missing, that goes in the headers section. I notice that you are stringifying the headers, you don’t need to do that, try sending the request without stringifying the headers.
      - Esau Grover Ocrospoma Callupe
        
        I sent whitout stringifying the headers but I get the same error.
      - Adolfo Garza
        
        You probably have the wrong API Key. Based on the documentation it seems you need to base64 a string composed by something + colon + apikey. For example if your api key is myapikey123546 then you turn it into the base64 version of: “randomstring:myapikey123546”. And then you send it on the “Authorization” header by doing the “Basic “. Check https://developer.mailchimp.com/documentation/mailchimp/guides/get-started-with-mailchimp-api-3/#authentication
      - Esau Grover Ocrospoma Callupe
        
        https://github.com/EsauOcrospomaCallupe/IntegracionesNS/blob/master/mailchimp_ue.js the same results, https://uploads.disquscdn.com/images/3a6f1722406e471de7a8f4fc35fc3e1c31ebf1b1f5c4268d34c378db1da2cce0.jpg this is a ARC Client of google and get OK in the conection with the same ApiKey (base64)
      - Adolfo Garza
        
        I have encountered issues in the past using the encode module to convert to Base64, it seems that Netsuite’s base64 doesn’t fully comply with the standard, so I only use it if I am encoding/decoding text within Netsuite. I think that’s whats giving you troubles. Try using this function instead: https://pastebin.com/BJQAvMca
      - Stanislaus Praveen
        
        Hi Adolfo,
        I have to accept the payment for an invoice by sending a link through email to the customer. He will get a form without login with the invoice details and amount to be paid, and for that customer will enter his credit card details for the payment. how can i achieve this using a external gateway. Please help me for this with a sample code
      - Adolfo Garza
        
        I’m afraid I can’t help you with that one. You need to talk to your payment processor and see if they provide a secure way to accept payments through the browser and go from there.
      - Adolfo Garza
        
        Nevermind about the Base64. I just created a MailChimp account and I was able to do a GET. I did it by two ways. Check it out: https://pastebin.com/M9QpKX5h
Sachin

Hi Adolfo,
I am trying to integrate NetSuite with Lazada. I need your suggestion do we need a connector to build this integration?
- Adolfo Garza
  
  It seems that you should be able to integrate to it without any connector needed. You would need to code the integration though. I don’t know if there’s any connectors already built for this but it would be worth checking out if you are not a developer.
shop07024

Hi Adolfo,
Thanks for this tips. We are trying to access REST AWS API gateway within a suitelet, can I do the same way as you do in this exercise? the AWS admin gives me the AccessKey, SecretKey, x-api-key for the API call.
- Adolfo Garza
  
  I think AWS does it differently, see https://docs.aws.amazon.com/apigateway/api-reference/making-http-requests/