Additional Resources

var filter = "";

var itemNos = IndexData.GetField("Item_No");

if (itemNos.length > 0)

{

 var gotAllItems = true;

 var currentLine; // don't set to 0, we want to continue in the next call

 if (!currentLine) // only set it to 0 when it's null / empty

         currentLine = 0;

 // add multiple item numbers to the filter

 for(var i = currentLine; i < itemNos.length; i++)

 {

         if (filter != "")

                 filter = filter + " or ";

         filter = filter + "number eq '" + itemNos[i] + "'";

         if (filter.length > 1000) // split up into multiple requests to not reach the maximum URL length

         {

                 gotAllItems = false;

                 break;

         }

 }

}

else

 RESTCall.NextRequest = "CreateInvoice"; // no line items found -> create the invoice

function FindIndex(arr, val)

{

 for (var i = 0; i < arr.length; i++)

 {

         if (arr[i] == val)

                 return i;

 }

 return -1;

}

var respId = GetItemIds.GetValues("value[].id")

var respNo = GetItemIds.GetValues("value[].number");

var respName = GetItemIds.GetValues("value[].displayName");

if (!Array.isArray(respId) || !Array.isArray(respNo) || !Array.isArray(respName))

 RESTCall.ScriptError("GET items call did not return the expected result.");

if (respId.length > 0)

{        

 // update the index data table with the values from the response

 var itemIds = IndexData.GetField("Item_Id");

 var itemNos = IndexData.GetField("Item_No");

 var itemNames = IndexData.GetField("ItemName")

 var itemPrices = IndexData.GetField("ItemPrice")

 for (var i = 0; i < respId.length; i++)

 {

         var ix = FindIndex(itemNos, respNo[i]);

         if (ix < 0)

                 RESTCall.ScriptError("Item number '" + respNo[i] + "' could not be found in the response.");

         itemIds[ix] = respId[i];

         itemNames[ix] = respName[i];

 }

 IndexData.SetField("Item_Id", itemIds);

 IndexData.SetField("ItemName", itemNames);

}

if (!gotAllItems)

 // continue with getting Item Ids until we got all

 RESTCall.NextRequest = "GetItemIds";