Hi everyone,
I want the .csv from this link https://falextracts.s3.amazonaws.com/Contract%20Opportunities/datagov/ContractOpportunitiesFullCSV.csv?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20230823T153417Z&X-Amz-SignedHeaders=host&X-Amz-Expires=2699&X-Amz-Credential=AKIAY3LPYEEX3RP4EDU2%2F20230823%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=2b764c67de514a52131ded50bcfb43228d440ab2e571b65e5551ec12e944bdc8 to be downloaded by Alteryx with all the data read in (ie the same as I would input this file in Excel format).
How can I achieve this?
Thanks!
Ignore, didnt work
Hi,
Thanks but that I achieved myself.
I need the actual .csv data (which is in the file) to be present.
Hi @insomned
Now it is working. Take a look.
But I still cannot see the data itself in Alteryx..
@insomned
The previous version was just downloading, this new one will be able to download + import it to alteryx:
But i saw now that the link that you provided expired, it had some embedded authentication:
This is great, thank you for sharing.
I hit a problem when trying to use it as the csv download file's data starts on line 6 - how would I insert that into the workflow to ensure I get the csv?
Thanks
[modified workflow attached]