SamS.06423 (AAA Life Insurance Company) asked a question.
We have an AWS S3 bucket that contains a json file. I would like to Download that file and transform into a list in a flow. The download object card from AWS S3 functions and I can open the file on my workstation. Is there a way to transform that downloaded json file into a List?
Hi @SamS.06423 (AAA Life Insurance Company),
Thank you for posting on the Okta community page!
I am not sure I have fully understood the use case of the question, but I have done some research and you have the capability to parse a JSON file into a workflows list. I have provide bellow a documentation about a function card that might help you with your inquiry:
On another note, the Okta Community Catalysts Program is now live. Collect online badges when you participate in the Okta Help Center Questions community. Learn more here.
Hi @SamS.06423 (AAA Life Insurance Company) -
Once you download a file into Workflows, you can't "open" it within the system - the main things you'll be able to do are things like send the file as an email attachment, upload it to Box or another service, etc.
I'd suggest you look at perhaps using the AWS Lambda connector, or the Custom API action in the S3 connector to see if you could just return a JSON payload. You should be able to invoke a function that will return your JSON payload.
Outside of that, you can manually copy/paste the JSON that you're downloading into a Workflow and use the functions to manipulate data, but in terms of pulling your data directly into a Flow from S3, I'd look at the suggestions above.
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
Hi @SamS.06423 (AAA Life Insurance Company) -
Once you download a file into Workflows, you can't "open" it within the system - the main things you'll be able to do are things like send the file as an email attachment, upload it to Box or another service, etc.
I'd suggest you look at perhaps using the AWS Lambda connector, or the Custom API action in the S3 connector to see if you could just return a JSON payload. You should be able to invoke a function that will return your JSON payload.
Outside of that, you can manually copy/paste the JSON that you're downloading into a Workflow and use the functions to manipulate data, but in terms of pulling your data directly into a Flow from S3, I'd look at the suggestions above.