Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
SOLVED
Query to Snowflake and Processing Data
Hello,
I have an easy question for the greater minds on here. I've created a simple https query to test snowflake environment. I'm trying to process the data I receive by iterating through it and I'm having some difficulty with that step.
In detail -
1. The returned results look like this -
2. the data is captured into a module that looks like this
3. Sample of data when passing through this get Data.data module
4. This is converted into an Array
5. Then iterated ...
Question - If I only wanted to read the email column in the next module, how do I do that?
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
So it turns out that it was the approach, after all, and the iterator module. I don't think the Adobe rep can actually say that 😄 but the solution presented does not even use an iterator but instead focuses on creating a repeater using the HTTP DATA module output only - not that far from what you suggested but with a slightly different approach.
- get the data
- use the number of rows value from data to set a repeater
- compose a string to use in another string - depth
- compose a string within a get ( ) data function, like what you had suggested to get the value
repeater config
first compose string
final compose string (ignore the double quotes and "+" symbols)
actual configuration looks like this:
results
