Alyc120 Member

Comments

  • I figured it out, I was looking for a complicated answer and it was just CSV, JSON, etc…
    in What is the list of DOMO CLI dataset types Comment by Alyc120 April 17
  • I worked with BT Partners. They helped me navigate the API (after I spent 8 hours researching how to do it myself to no avail). In addition to working out the details of the API connector, they also and provided JSON code to paste into Magic ETL. I was up and running in a jiffy with their experience. It was worth the…
    in How is everyone else connecting to NetSuite? Comment by Alyc120 April 3
  • Hi Mark, Thanks. I can dig in DOMO to see what's stale. But I lost a much simpler method which was in Workbench 5.1. Can I add a field to the list of DataSet jobs in WB 5.2? I work with 14 WorkBench connections. I can quickly identify which connection has stale data, but it was beneficial to pull up the specific PC's…
    in can last run date/time be added to workbench 5.2 dataset view? Comment by Alyc120 April 3
  • I worked around this by adding a CONCAT formula in Magic ETL. My File# needs to be 6 characters long. This worked for me. CASE WHEN LENGTH(File#) = 5 THEN CONCAT('0',File#) WHEN LENGTH(File#) = 4 THEN CONCAT('00',File#) WHEN LENGTH(File#) = 3 THEN CONCAT('000',File#) WHEN LENGTH(File#) = 2 THEN CONCAT('0000',File#) WHEN…
    in Uploading Excel - Data Type Issues Comment by Alyc120 December 2023
Avatar