Connect Exact online with n8n via HTTP request

Questions
22

Checking that out

23

@ieceetee fixed the issue. Please pull the latest changes and try again. Thanks.

24

@RicardoE105 Thank you! i got it up and running, after a few times i get the following error:

ERROR: Error: The request is missing a required parameter, includes an invalid parameter value, includes a parameter more than once, or is otherwise malformed.

Error: Error: The request is missing a required parameter, includes an invalid parameter value, includes a parameter more than once, or is otherwise malformed.
    at Object.execute (C:\n8n\packages\nodes-base\nodes\HttpRequest.node.ts:846:12)
    at processTicksAndRejections (internal/process/task_queues.js:97:5)
    at C:\n8n\packages\core\src\WorkflowExecute.ts:596:26

Down here is the error from the console:

REQUEST {
headers: {
accept: ‘application/json,text/*;q=0.99’,
Authorization: ‘Bearer gAAAAG9qTkIJfs2_O92Wo0AkDJ_cQfyvMji2LEQkiWtxLSyqRApFBPB2yMvgoduSo0MSCMI9dlup_6eSaeIRMtVGPkbX3Yq4EJiE8B-kgciqJnA09hJMg1Wf31za5Wn1IGPYsHcnkPPGu6cKjWjulocDj7nsgCgC0uSUGABx5n5Tu8mNBAIAAIAAAACTFZDlOptAoTD3j-SuCIwSAMHR3HJOTumUCrSf_5NkN8Zd-SwOpSI4V_5_7_1rQi5H9aMDbBiIjNnLin5v4QJBnkqt7MKWRBDFZH3QLNi8XhSLQrBEhUf9AxfBshj1X3g9vIGn8gdcaGE66Cg6Tsc1SCvvKUMdadlRkecN0zQBaKTdAjFAZdxCCnBRh9bXAIqKML2IIBg__qV_wduQkhuKz6bwXxsoKIs5zObgevRSYryEGdqKbzjUssm3BCVAuwS9rVF-TbHIm50eKRKBZp0X1dAC74i6tadRNIp8xStEc-dQLUtdFUzSpoUJ_qdpX8oy95ZZeGBKLTqPU6zm2kDnhgkrYXMeqLfsEpWVuzUMepY7cx7uwU0g3MFwMRlmjpPwxArT4XY37Pjvcho4Tuu7abxj43dvGgcuVwWL5dConLR5GBf24aL-lejHILoiP2CZDxpeAY3UkCEu4uazNL0KHgznBlchJN58XXAeb7XQN5PWukrdJ1iJgzPoBOUQcHsg77pb2gxrAdYNLCu69B6yONzZnibWXEr34f2_M6pcf_IXFbzoJ559Jub24b062oT_Ld-3ouEQUQ0GtlEsJxt1fzVpYXMykQ6v_8YPVu2zShoVuU1Bo96J4ItxDvMfVhcv2xRwbsroy5zsoYmQBZ_g1Jxx2oOwy9vhCHXdVpPVjg’
},
method: ‘GET’,
uri: “https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales eq true and trim(Email) eq ‘test@ieceetee.nl’”,
gzip: true,
rejectUnauthorized: false,
resolveWithFullResponse: true,
timeout: 10000,
json: true,
callback: [Function: RP$callback],
transform: undefined,
simple: true,
transform2xxOnly: false
}
REQUEST make request https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’
REQUEST onRequestResponse https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’ 401 {
‘content-length’: ‘0’,
‘cache-control’: ‘no-cache, no-store’,
pragma: ‘no-cache’,
expires: ‘-1’,
reason: ‘AuthenticationRequired’,
‘www-authenticate’: ‘Bearer error=“invalid_token”,error_description=“The%20message%20expired%20at%2010%2F28%2F2020%201%3A06%3A00%20PM%20and%20it%20is%20now%2010%2F28%2F2020%201%3A07%3A33%20PM.”’,
‘x-xss-protection’: ‘1; mode=block’,
‘x-content-type-options’: ‘nosniff’,
‘referrer-policy’: ‘strict-origin-when-cross-origin’,
date: ‘Wed, 28 Oct 2020 12:07:33 GMT’,
connection: ‘close’,
‘strict-transport-security’: ‘max-age=31536000 ; includeSubDomains ; preload’
}
REQUEST reading response’s body
REQUEST finish init function https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’
REQUEST response end https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’ 401 {
‘content-length’: ‘0’,
‘cache-control’: ‘no-cache, no-store’,
pragma: ‘no-cache’,
expires: ‘-1’,
reason: ‘AuthenticationRequired’,
‘www-authenticate’: ‘Bearer error=“invalid_token”,error_description=“The%20message%20expired%20at%2010%2F28%2F2020%201%3A06%3A00%20PM%20and%20it%20is%20now%2010%2F28%2F2020%201%3A07%3A33%20PM.”’,
‘x-xss-protection’: ‘1; mode=block’,
‘x-content-type-options’: ‘nosniff’,
‘referrer-policy’: ‘strict-origin-when-cross-origin’,
date: ‘Wed, 28 Oct 2020 12:07:33 GMT’,
connection: ‘close’,
‘strict-transport-security’: ‘max-age=31536000 ; includeSubDomains ; preload’
}
REQUEST end event https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’
REQUEST invalid JSON received https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’
REQUEST emitting complete https://start.exactonline.nl/api/v1/2794323/crm/Accounts?$select=ID,Name,Code,Email&$filter=IsSales%20eq%20true%20and%20trim(Email)%20eq%20’test@ieceetee.nl’

25

@RicardoE105 If you want i can give you the login info to test.

Thanks

26

ahhh that would be helpful. You can send them as a private message.