Excel Power Query Json.Document(Web.Contents

[hat360]

Hi, I am using Excel and making a Json.Document(Web.Contents connection through to an inhouse system -

Json.Document(Web.Contents("https://outinternalsystem.company.c...TFul/GetShipsByLRorIMONumbers?LRorIMONumbers="& fnGetIMOToSearch("ParameterTable","IMOToSearchList1")))

IMOToSearchList1 is a TextJoin field of 100 unique numbers (separated by,) that are searched for in the system.

I now need to increase the number of unique search numbers to 300. TextJoin doesn't allow me to do this as the generated result is too large (each number is 8 characters). Is there a way to create a function that gets called for the search that performs a "while not EOF" and insert each of the numbers from an excel table?

Any help/advice would be greatly appreciated!

Thanks

 

[hat360]

don't worry, I've sorted it. created 3 different tables from 3 different sources (each containing 100 entries), then combined the tables together.