Searching by Lookup Field Stopped Working

Searching by Lookup Field Stopped Working

Hello,

I have code that has been working for years suddenly stop working a few days ago, around 2020-Dec-03.

The lookup field used to have Field Name "HH ID", Deluge Name "HH_ID" and Field ID of "HH_ID_ID".  Despite the awkwardness it worked for years.  Thinking the problem might be caused by a Deluge Name ending in "_ID", I renamed the field to "Household" which updated code throughout, but the problem persists.

  2. void Test()
  3. {
  4. //assoc = zoho.crm.getRecordById("Recalls",2383098000027466297);
  5. //info assoc;
  6. fulfillment = Shipping_Info[Fulfillment_Name == "Endpoint"];
  7. info fulfillment;
  8. shipments = Computer_Shipment[ZIP == "02476"];
  9. info shipments;
  10. for each  shipment in shipments
  11. {
  12. info shipment.State;
  13. info shipment.Household;
  14. }
  15. oneShipment = Computer_Shipment[Household == "13498"];  //This line gets error
  16. info oneShipment;
  17. oneShipment = Computer_Shipment[Household_ID == 2383098000012721115];
  18. info oneShipment;
  19. oneShipment = Endpoint_Shipment_Notice[HH_ID = "13498"];
  20. info oneShipment;
  21. }
Here's what I get:

I've noted which line gets the error.  Even though from the code above, you can see that the set of Computer_Shipments going to ZIP Code 02476 contains a Computer_Shipment going to Household 13498, when I search for the set of Computer_Shipments going to Household 13498, i get that error.

As it suddenly broke, I'm wondering if something happened on the Zoho side.

Many thanks for any help anyone can offer here!
James