Tried this now.
Adding params separately does run into a 400 Bad request error.
But, surprisingly, just JSON.stringify-ing the parameter value resolves that issue for the axios call via the native nodejs code. No other encoding or options required.
const axios = require('axios');
const params = {
filter: JSON.stringify( { _and: [{ id: { _in: [4501, 4609, 5022, 6952, 8294, 4490, 5484, 6165, 6440, 7675, 4205, 4756, 6998, 7161, 7190, 5086, 5451, 6566, 7146, 7584, 4481, 4993, 5772, 7373, 7531, 5196, 5691, 5933, 6402, 6479, 5109, 5169, 5468, 6223, 5767, 7153, 7618, 7847, 8202, 4991, 5556, 6923, 8249, 4449, 4682, 6260, 6450, 7756, 6009, 6036, 6067, 6485, 4701, 5184, 6061, 7401, 5066, 5179, 7575, 8030, 5271, 6564, 6614, 7267, 7489, 4849, 5422, 6121, 6187, 7772, 4351, 5791, 7867, 8020, 4345, 5172, 7215, 7243, 8299, 4383, 4811, 5239, 5974, 6018, 5124, 7009, 7062, 7853, 7975, 6556, 7393, 7484, 6319, 7519, 7593, 4939, 6534, 6660, 4413, 5983, 7463, 5881, 6347, 7022, 4714, 5415, 7304, 4816, 5824, 6880, 4983, 5638, 8139, 6892, 7503, 7927, 5750, 5864, 7642, 5315, 7149, 7903, 4676, 4921, 5117, 7264, 8078, 8168, 5504, 5619, 6912, 6043, 6309, 6867, 6298, 7471, 7855, 6100, 6838, 7619, 5727, 6071, 8227, 4759, 6372, 8170, 6228, 8189, 4240, 5747, 7560, 7021, 7294, 8001, 4286, 7394, 7592, 5739, 6289, 7606, 7984, 5960, 6239, 6790, 7336, 5305, 7826, 8181, 8265, 4409, 5400, 5921, 4640, 5069, 7655, 4949, 6542, 7360, 6975, 7888, 7976, 4357, 5474, 7958, 7455, 8074, 4696, 4787, 5626, 7045, 7350, 8322, 6109, 6969, 7097, 4754, 4906, 5896, 4766, 5158, 7805, 4505, 5419, 6376, 6609, 7440, 7808, 5416, 6535, 8220, 6244, 6508, 8076, 4678, 5011, 5603, 6241, 4451, 5601, 6531, 7977, 4412, 5431, 6297, 7061, 5802, 5902, 6282, 8392, 5010, 5324, 6088, 8066, 4547, 5209, 5574, 5786, 6208, 4673, 4772, 5637, 6570, 5182, 5448, 5698, 8379, 5932, 6135, 6245, 6789, 6254, 6336, 7521, 7762, 4237, 4263, 7840, 8193, 4556, 4761, 5349, 5440, 6024, 6756, 7803, 8313, 6091, 6525, 6544, 7011, 7868, 4455, 4838, 6025, 6665, 5910, 6140, 6472, 8391, 6219, 6885, 7955, 8360, 5339, 5869, 5926, 6327, 8339, 5552, 6183, 7750, 8101, 4721, 6197, 7603, 7718, 6957, 7035, 7105, 7260, 7889, 4864, 5083, 6589, 7121, 7663, 4829, 4956, 6020, 6095, 6935, 5823, 5827, 5889, 6930, 8126, 4279, 4970, 5260, 5667, 7053, 4865, 5265, 6842, 7051, 5013, 5719, 6538, 6816, 4393, 5088, 6821, 6958, 5585, 5796, 7156, 8110, 4382, 6272, 6781, 6877, 8014, 6857, 7085, 7130, 7219, 8111, 4726, 5193, 5523, 7807, 7876, 4404, 5037, 5190, 5230, 7610, 4533, 5701, 6226, 6504, 8352, 4768, 5567, 5976, 7405, 8212, 8242, 4519, 7056, 7841, 7906, 5219, 5702, 5918, 8366, 4711, 5807, 6465, 7830, 4985, 5211, 6213, 7615, 5406, 7379, 8137, 8319, 5227, 5553, 5617, 6700, 5893, 6098, 7088, 8011, 5114, 5922, 6683, 7037, 5161, 5163, 6628, 7398, 4647, 5471, 6698, 8104, 4938, 5673, 7591, 7739, 5118, 6182, 6365, 7534, 4783, 7093, 7099, 8234, 4439, 4612, 4828, 5327, 6079, 6740, 8134, 8349, 4260, 5876, 6337, 7554, 8230, 4290, 4872, 5020, 5033, 5968, 4359, 6227, 6618, 8177, 4992, 6464, 7917, 8035, 6922, 7074, 7126, 7372, 6322, 7043, 7962, 8132, 5405, 7234, 7281, 8047, 4477, 6401, 7069, 7668, 4305, 4979, 5095, 6604, 5663, 6270, 6588, 7414, 5034, 6022, 6723, 7483, 4243, 5674, 6103, 6117, 5388, 6332, 6558, 7384, 4786, 5975, 6381, 7280, 4261, 4276, 4879, 5757, 6148, 6421, 4430, 4755, 5302, 6661, 6944, 7141, 4869, 5665, 6164, 6563, 6979, 4851, 4950, 5119, 5437, 6865, 7659, 4353, 4728, 6015, 6763, 6909, 8083, 5021, 5508, 6657, 6768, 6805, 7246, 5284, 7259, 8287, 8309, 4969, 5596, 6565, 6741, 7348, 7537, 5056, 5611, 6369, 6562, 8094, 8199, 4707, 4731, 7192, 7397, 7993, 8374, 4348, 6541, 7170, 7611, 8280, 8338, 4881, 4915, 5653, 5952, 6029, 8372, 5686, 6888, 6938, 7518, 7994, 5140, 5916, 6864, 7574, 8266, 4748, 6139, 6788, 6830, 6920, 4407, 4452, 6517, 7375, 8167, 8194, 4400, 5549, 5830, 6848, 7590, 7869, 5068, 6364, 6996, 7276, 7309, 7486, 4362, 4444, 4947, 6329, 7181, 7524, 5546, 5865, 6258, 6392, 7042, 7109, 5908, 6057, 6119, 6176, 6594, 7106, 5520, 5550, 5929, 6934, 7696, 8204, 4207, 4476, 5243, 5412, 5605, 8019, 5075, 5891, 7380, 7872, 4308, 4626, 5418, 5634, 6130, 4844, 4944, 6495, 6823, 6849, 4503, 4550, 4863, 4914, 6824, 6081, 6361, 7288, 7982, 4524, 5541, 6484, 7462, 7115, 7452, 7501, 8307, 4212, 5076, 7506, 8123, 4380, 6277, 6738, 8302, 5773, 6451, 7297, 8060, 5288, 6221, 6739, 8082, 4292, 5379, 6062, 6335, 5269, 6852, 7063, 7817, 4741, 6656, 6809, 6874, 7133, 7643, 4379, 6430, 6825, 6954, 7831, 4288, 4656, 5868, 7443, 7733, 7928, 4324, 7070, 7262, 7448, 7871, 4529, 4765, 6548, 7413, 7953, 8378, 4683, 4876, 5455, 5994, 5997, 6707, 4595, 4904, 5944, 7549, 7587, 4895, 5009, 5048, 5874, 8211, 4340, 4842, 5507, 6616, 7594, 4951, 5481, 5999, 6685, 7862, 8072, 4624, 5017, 5091, 5134, 8063, 8290, 4687, 6645, 6845, 7555, 7766, 8314, 4936, 5697, 5748, 5875, 5954, 6610, 4280, 4514, 4862, 6274, 7091, 7516, 4606, 4760, 5936, 7427, 7674, 8306, 6013, 6142, 6203, 6321, 7989, 8133, 4252, 4443, 4485, 6222, 7790, 8064, 4916, 5032, 5880, 6084, 7176, 5542, 5680, 6579, 6757, 6910, 7134, 4660, 4712, 6543, 7131, 8345, 4438, 5321, 7136, 7571, 8152, 4272, 5242, 5543, 5566, 7118, 7630, 8016, 8089, 8269, 8279, 4667, 5615, 5811, 6607, 6752, 7352, 4422, 5077, 6680, 7468, 7570, 4468, 4516, 5740, 6552, 7132, 7439, 4509, 4717, 5027, 6383, 8255, 4355, 5318, 5328, 7076, 7689, 4830, 5258, 6502, 7189, 7525, 8010, 4480, 4649, 7912, 8033, 8098, 4693, 5714, 5804, 7319, 7740, 4218, 4587, 5320, 5385, 8038, 6263, 6380, 6694, 7711, 8380, 4806, 6216, 6639, 6962, 7878, 7527, 7738, 8049, 8130, 8271, 5356, 7125, 7735, 7897, 8069, 4312, 5359, 6292, 8373, 5729, 6452, 6536, 6603, 8264, 5809, 6287, 6734, 7651, 8201, 4302, 4361, 4597, 6492, 6786, 6963, 7004, 7988, 5837, 7239, 8085, 8293, 4670, 4920, 5885, 6458, 5087, 7656, 8087, 4543, 5201, 6577, 7747, 5024, 6520, 8301, 4369, 4472, 4681, 4767, 5649, 5717, 6279, 6436, 6553, 6581, 7054, 8109, 8340, 8376, 4255, 4306, 4435, 4487, 4727, 4747, 4945, 5120, 5226, 5266, 6507, 6650, 6658, 7295, 4274, 4493, 4692, 4962, 5040, 5855, 6278, 6456, 6961, 7303, 7755, 8159, 4599, 4831, 4903, 5189, 5940, 6251, 7151, 7162, 7182, 7365, 7798, 8188, 5307, 5430, 5464, 5873, 6178, 6792, 7558, 7580, 7741, 8029, 5003, 5008, 6494, 6927, 8090, 4233, 4517, 4807, 5317, 5341, 5816, 6115, 6159, 6304, 7438, 8100, 4295, 4343, 4650, 5126, 5215, 5912, 5995, 6333, 6753, 6785, 7257, 4989, 5493, 6259, 6445, 6686, 7473, 7752, 4924, 5442, 5462, 7206, 7446, 7728, 7819, 7960, 8045, 8075, 4273, 4313, 4428, 5563, 5659, 6432, 6640, 7418, 7749, 4227, 4321, 4933, 5854, 6555, 6654, 7391, 7498, 7601, 8353, 4586, 4853, 5051, 5225, 5833, 6021, 6253, 6960, 7690, 7769, 9456, 9449, 9450, 9451, 9452, 9453, 9457, 9458, 9459, 9460, 9462, 9461, 4709, 4534, 4836, 8245, 4639, 8291, 6759, 5137, 7165, 6149, 8157, 5138, 7148, 4738, 4591, 7546, 7771, 6851, 6715, 7694, 4636, 4892, 6596, 9322, 9325, 9323, 9324, 9321, 9317, 9320, 9319, 9318, 5721, 4563, 7055, 7880, 6806, 6684, 5745, 7972, 5390, 7649, 8165, 7214, 7686, 6695, 8117, 6434, 6411, 5754, 4402, 6854, 6039, 6891, 4661, 4427, 5831, 5241, 5706, 7476, 7514, 4571, 7895, 6156, 5264, 8231, 6330, 7731, 5094, 7588, 7340, 7983, 7918, 5286, 6240, 7513, 6953, 7419, 5761, 6348, 7172, 5657, 7272, 7797, 6955, 7286, 5414, 5760, 5042, 6967, 5923, 5046, 6409, 8012, 6483, 6250, 4982, 4961, 5559, 5545, 7647, 8233, 8120, 5616, 8237, 8003, 6387] } }] } )
}
let config = {
method: 'get',
url: 'https://webhook.site/34bb0329-244d-469d-b3c5-d75d191d01a6',
params
};
axios.request(config)
.then((response) => {
console.log({ status: response.status });
console.log({ response_headers: response.headers });
console.log({ response_data: JSON.stringify(response.data) });
})
.catch((error) => {
console.log(error);
});
Don’t really know the difference between this scenario and what Axios (inside n8n) is doing, except, this is the config used by the Axios in the raw Nodejs app:
So, to not having to give up the usage of httpRequestWithAuthentication in the custom node’s API calls, will resort to breaking down the payload into chunks, for now, but the issue seems to be with n8n’s implemtation of Axios.
