getRecords - Avoid duplicates

getRecords - Avoid duplicates

Hello community, 

I'm maintaining  a Vendors table in creator, fetching data from Zoho Books. The vendor table can not contain duplicates for consistency in the records of my app. That's why I've checked the "No Duplicates" option on the contact_id fetched from Books. 

The issue now is that everythime I'm running the function to get records, I receive an error message because of finding duplicate values. How can I skip duplicates in the function below ?

Thanks a lot for your help. 

  2. void Get_Suppliers()
  3. {
  4. query_param = Map();
  5. query_param.put("contact_type","vendor");
  6. response = zoho.books.getRecords("vendors","00000","query_param","booksconnection");
  7. data = response.getJSON("contacts");
  8. for each  getdata in data
  9. {
  10. vendor_name = getdata.getJSON("vendor_name");
  11. contact_id = getdata.getJSON("contact_id");
  12. contact_type = getdata.getJSON("contact_type");
  13. insert into SUPPLIERS
  14. [
  15. SUPPLIER_NAME=vendor_name
  16. SUPPLIER_ID=contact_id
  17. CONTACT_TYPE=contact_type
  18. Added_User=zoho.loginuser
  19. ]
  20. }
  21. }