Load Table Objects using name IN ('value1', 'value2', 'value3)

Andreas_Marinopoulos · January 6, 2021, 1:58pm

Application ID

4A47197B-AE30-FA84-FF56-0071F4010900

Expected Behavior

I load table objects using a where clause containing a list of ids.
I want to return the respective list of objects.

Actual Behavior

In apitoJson* I am first creating a list of ID’s that looks like this:

[
	"lead_Iy9XnWEMvLMV9EpWpYqaUJZXvGnmcmdFmxD9KKPmH4V",
	"lead_rhJOH4p9c0XL6KcnxKzzrpXkwLnNqa4pQTdHJy8NWEN",
	"lead_uljUsAW3WrvO7lRIuumttPIXvM25CHXSaKCntyjyVlv",
	"lead_RQ9A4QSg3kK099CFGPTFR5C5zRvDeIaIbjSoCvNBWWt",
	"lead_a1czvRXN7jVxs6Jz1XlG3RNe93aY8tghNz6qDv9bBY9",
	"lead_vIF4STxEw9nAO320uCYoPMUSL0nUHDW8qUlVXLslToQ",
	"lead_cqnvkVBt7Gkifs7neYmmHN2WUbY3jySSZbAbnCpF8nH",
	"lead_iGHjGOBGcY3Chyeju9Kg5b764q2LQXc74QohVu05rmJ",
	"lead_LXfwfLZA8Xc7dpVdEFCH0jdUtvwg2PvZHwHW4UZik7S",
	"lead_OZ9aylvPMYpnimdmaGLLXMIgiXjmO2A7LX3RzpiLoWM",
	"lead_6VxzEi8MbzJGYYmSUaeUJpVt7Qw5WgDzDAyLZgiwe01",
	"lead_MErcm0qc8cT9j1zdj8t5sXSUdjoOTBSTSS5qd754E1c",
	"lead_Is69v0exgsYWUqlllFMIPGhKGkZzP0UpwR3j0PRP2fI",
	"lead_KsNR9mdMQBKDBq8UqQQ5t5Afd0wcULQOIj2hYfs1dKn",
	"lead_cs1PFIJnC9Y6LnLWHDcWN6vY4PjTkR9wG6T0U4lz3Kf",
	"lead_xYdTpoSrYCSrZhfKqqA2QUh0rqldXxNpfVmdT52FRAm",
	"lead_hRaS99I1NCTg2UAevXQ4JxXtByBYxokMk9KEnVG8ijL",
	"lead_cb9ndBfp5XrQbWDKahW42LYfSBtWyJwyyc41QI4tzQJ",
	"lead_T6b9JWcjXeWGEtov3419n4uv5qIJ6mxXQwtRYZA8r7Q",
	"lead_Jbq3foRlol0HPQCGoRTsjYClFcKSSxjEnrXvZnCVpeU",
	"lead_qVRqKEwNlIVXjmtQPvoRFAT2ce0adQtYh9lvGWiRv4B",
	"lead_ALLGLgDZzQl84UjGGPy4sN75Ay2XWCwXANUWDVCksqs",
	"lead_ckks4BT4xNJfwFv64mlcMsxw9g9L2nSCVHq40OV1kJ9",
	"lead_vzu4aYSb1UfDaZlrlCjSbZXQ7udBOyTVgp9h4Ph57Pl",
	"lead_HmyyJ16d4YJVxBrWXXPpPu2Qc3ei2fIsXAZmc7vbxh1",
	"lead_02KNK3QLg1WKGPTdHOq0tDLFww8iF3e95aGpzaXigw1",
	"lead_eImgv3ava2Fck7JhYltYn24wfvkKWrxrNaowL49ElQW",
	"lead_Y0vI5y7QsAaN1subPC9oQd8DYLqv3J4PpnH5NycOETy",
	"lead_UOuzEGGhxe8dCPUg7iRdN3oLyW8gRZJvP7Z5AZnj6JI",
	"lead_TSUM9HVvFBhqeEqAB8wMpyRNOKWmspuEQHJZv7d8nLK",
	"lead_pfhaTocTsau7upz1fHI4fC7EmyIURGrHH3U9FlLPmSo",
	"lead_pmKZeuEnSfxVdNiW5qxG2r3H4q6WHKO7p578azQi7D5",
	"lead_SL20a5cbQMClRe5eRHF3PZB3ynIi9BmELu8dDIIpBMP",
	"lead_WIiW80lbbjtuoTx4TZkRbCOfXUHAToGP4OecgpB2FZa",
	"lead_hCK0CqdgrzLkVatIoHts9IqDBvQvAWP5KhXNcl9gdVQ",
	"lead_5K7YnoAEiZx3N8MAbRahs7C5d1LCbi8quiEh0tBe4IR",
	"lead_L3PxpODScHmydG7mCpyER8kb5DMrdRao2PJ9fmeyVR9",
	"lead_6F5jTEVg3BJ8aqoOhRCAR6IEVNjolGzGD9PJUrTFyvq",
	"lead_EvrL2Lo2WxgNSwhMc59cu7Ht0hzObh8RMDr7YnWwIvo",
	"lead_KMRqdXjLsti6yAeTeyd7EQO6NhY4VkxFCj2YGX2XYWZ",
	"lead_4LK5CGr9TphjWoXqewSRrpBqW5vAvXeTIfj39uSo2xp",
	"lead_bYUlupnLgrkMdpWvhbmzu844FhsoyxkXCgfO5f4baoi",
	"lead_lpgbnKewCaA8zy214sijbhFIEBJqN34nohzLzBExJh2",
	"lead_prGL3BmFRqjj8sQ44rO37alzNkVTmqMhr6D32RZffX2",
	"lead_t7t7kb0FnLXJCxoeI7N7R6PaMOzKerZSuXCsFrRII0v",
	"lead_Xav3D14zRnztIZMd7xH37xl5vOWr2cfCqGljcOmmwnR",
	"lead_FxGNdjjSgNskX87G1l0MAaztwJqjkLV9SGxHxhhKf7O",
	"lead_l83qvMqnGFcamtvelotQyyuSLmIiA3CGuRf2Z4jAfzW",
	"lead_m6PKEp5RsgJC0id99ZtRSdmErh7B4HWULV64y1xrfZb",
	"lead_ss640aBAMx0zWVCqwugqQaWw80tiSqVm1dtVPgWs8o3",
	"lead_U9wAFhjwsWfaeYh7LgdLFvkjvSqvC112AtW5Ei5a80Z",
	"lead_IUsogxk2KUXcdlxb0tmuzF4kERSeIsRuYhvgOOPhrKw",
	"lead_ZiBXDnmBXV0PfeJ9gQkZPVLrul57awjotekDT3P1e1i",
	"lead_1NyqHLsErje2eENS9hR2VWj2ySoGHEw5nQgVXsX5aTX",
	"lead_5ZdOVC4ZzuwpfHee5MOEFK39jRR24XxXxft86sjWcvT",
	"lead_ch5y6IiYGE3uWKdfdxVqJKjPbk5lTfHeCjN5Lzg0g2m",
	"lead_ISleeFHe5hwvVu4XRs6CrbSmISVNepZLZ13ZaoN0fy9",
	"lead_s0LQfma17GoD6UIuIreGKOBp88Y9dKhftn9ZELPOFWE",
	"lead_QSTc8FmPwIBiyUTbNI22yeaNUaujfNkuEVEbwUpR6Nt",
	"lead_snq1kj9Pe70O32tqY0QCfRfn4ZmON1b0ptTUNAE0a1s",
	"lead_BrCtthJi8w4W4qTc9sah8tVO8lG9z7ovil4qxbBAwvL",
	"lead_it1cTY3TYjXLquFiKvJ6K2hVbi16l6IispalKZTgT66",
	"lead_pNLxnUct5FwmoVjdznGlYaDdBuoPiQVs5XU6suoWxD4",
	"lead_ocvAhcjwM6oA5GEswuITQXgrFjREdgeg3TbKRTVNM5C",
	"lead_vLV2InzhxSpT89K9bFfqgRfslO2lTnedmDC7qCQ9iWm",
	"lead_p1kUZ0Y9GfxAr6NwnNAn4ZbSEc6nsDzWods4RywE466",
	"lead_PeFpKyMTVQGxamLQJFzW40NwW0Rs24WNB6HfjowDf1I",
	"lead_KegZTDJM0UPs85Y0T1PLWPTm3jvV8D2uRJOANMmdcpY",
	"lead_6ysAxtD5FjNrm1j2nwxYlcSzXWu2NTdbF5qgcmwDWuj",
	"lead_Fygz27ARCvFhvv7jyrqpSdnycXW4kaIDuLlAAXRVY6T",
	"lead_pKjbFTtEqRutTqP4lCEEgrbNugUIutOU4p33Pjy5E8c",
	"lead_WgISBjPCpcAm2F5XyzK6PsiwMEiefmC3cKdYxLUfjU6",
	"lead_frWlAYy4gLVyLJZyWkrqX3fxvSr9XeZZcMKOzLNI1Fh",
	"lead_C7ZXvGVjruy0ZejDzRdmJcTks23qGit59Uff17dTnOM",
	"lead_1OBGB1luRc36hhfhWwffwJGUb4NSVuBHYrmAAF2dc2b",
	"lead_iNfM9Mo6kkVq1zuCLXncyVZFCBDM99ERlkvHbKeTULY",
	"lead_SnrrBOHZk5ks4YHFbMweARfJlrlGLJKCrN0NMc5KzoZ",
	"lead_R0uaBrG97LCiThbWrzCoVUPXAzXHzgdBEkRdGwHNTho",
	"lead_DaUrzxIEPLgbGEZcPg7KLJFp30AAU6V1NlGis8EqmIO",
	"lead_VRXH1aCfU5ThgNT51h3gXLQ65wP7wHNsS7NFYBPj5M0",
	"lead_cPb8Chj8D43JeJxhOSRCmz3Ysfv0VSkv3pjOwnMOs2S",
	"lead_mfhYp2lqMxvTCxhkn53tE3jMeP5eHPWmDQwMojkTjc8",
	"lead_n3HPhTqIPziSrZ3ZX56jeFb1kp8FGy0yJi6J4wnpMrl",
	"lead_va50HEvF6PYVAtGhUIRhpR3tnhpG10Cf8PTNdym78e3",
	"lead_RtV7D7Fy8QMik0csb9Zp8Nshy9XyUcCVyHtQ2WpSXd2",
	"lead_Dd21mLDCOHKGpUp5HoLj48b5wQ87ebzAnUMpyVt7pVp",
	"lead_W3kevNoSc56lCt4k6OCwWIqZIVdeOlZOk6iSiStU9ab",
	"lead_T13UtU7T1APfVaqj7sv6gxZWGXJYduq14DO7VTg15FF",
	"lead_de0sb88GeVopGxz01fDcea5V6Pg4kC3psUXTJ1I7LWs",
	"lead_GvuspUlyOKIVSvqXkEnxRdWl0ztqS53p8zQY26d3Lb6",
	"lead_h9jQ6lkrh6XFbOWyhR0nQ9CUs4WS3VQPdJIDXtbVyKQ",
	"lead_vq5GIEbFlmZ8TwcWgnOPMnmsc387WfjFBQFx83W971z",
	"lead_yCEuyiC5bTnchc3JZSLBuawfji40AXU3I2R48fSCV3o",
	"lead_HgJ6dON1dAqHK92su2FkOgmcc3Xz6PSvM6hPYwAfCKl",
	"lead_awJ5sArByDemnJtJMND2kowCcZrLKupyGfpzQrbWdML",
	"lead_np2Wsw06cuCY1RS7yzBacEnHiTGct22NKcFvks12Snh",
	"lead_Wu0iEf6oLBxjAe5z3awxDsrI7uzJtPRJWlLP0Q6WVK6",
	"lead_G6x1cmlDTTmtJ9FNQqpCM16AvGlH1O2pbEaOa298PhJ",
	"lead_QVUOCopPsyIqt3UojUwrZ1vTXkhoIgVDD5F7UOmI0wn",
	"lead_5ICI67GaBRDCVqfBlKE2LX7SIiRLn0fn4pen6CnOpZa"
]

and I then want to Load Table objects that correspond to these IDs.

If I do it 1 by 1, it works, but I often get execution timeouts.

So I want to try and upload them in bulk using name IN ('value1', 'value2', 'value3)

This is what I have so far:

and I get:

{
“code”: 0,
“message”: “URI length exceeds the configured limit of 2048 characters from 10.42.38.235:52566”,
“errorData”: {}
}

Volodymyr_Ialovyi · January 6, 2021, 3:08pm

Hello @Andreas_Marinopoulos

Codeless bloc Load Table objects use route with method GET and and the GET methods have a limitation on the length of the URL, that’s why this error occurs.

I created an internal ticket (BKNDLSS-23694) to fix this.

While I can offer you:

Use smaller IDs
Search for fewer IDs
Change the logic and load objects in the place where you extract their IDs.

Andreas_Marinopoulos · January 6, 2021, 6:43pm

I am not sure I understand your 3rd suggestion and it sounds promising, can you elaborate on what you mean?

My desired outcome is to compare the list of objects coming from an external API vs the list from Load Table Objects based on the updated property.