Best Of

Re: Data in Email Subject Line

if you select the "Download from link to page" option, and then choose file type "Email Body as one row" it will create a column for the email subject line and a column for date/time received.

ggenovese

2

Re: Sharepoint Online Rest connector - "selected file may no longer exist"

Yes, its probably related to the user deleting the file. Files normally will have a unique identifier in the background that let's the application know the difference, even if the names are the same.

ArborRose

1

Re: sharepoint connector - server relative url

You don't need "/sites"..
Once you select the Drive ID, or the document folder, the relative path is relative to that.

So if your main folder you select is "MGMT"

Your relative path would be "/Equipment"

Craig_Lynch

1

Re: Using Replacement Variable with sql query on workbench

Thank You! I missed to seed the replacement variable with id. I was able to resolve this issue by adding a value to the replacement variable.

Lp_gsp

1

Re: Using Replacement Variable with sql query on workbench

it looks like you're not using the replacement variable in your SQL statement it should look like this:

SELECT id, name, source, dateAdded 
FROM tablename
WHERE id > !{lastvalue:id}!
ORDER BY id ASC

and then make sure to seed your replacement variable with an id that you would like to start importing with, then once it runs successfully your value will be updated with the last value that you imported.

https://domo-support.domo.com/s/article/360042932734?language=en_US

ggenovese

1