Query to Snowflake and Processing Data

[D____D]

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? 

[Sven-iX]

You can do

• Iterator on Data.data
• then grab the 4th array element: get( {the value from the iterator} ; 4 )

[D____D]

Okay that sound promising ... I just came across the get function but used in different way than this.  Let me give that a try.

[D____D]

Hmm no go. 

Can't "iterate" on {{#.Data.data}} because it's not an array
I have to use my created array 

.. when I try your idea 

Comes up empty ...

The issue seems to be that the iterator is putting the values outside of "Value" .. i have actually never seen this behavior before ... here's what I mean ... 

[Sven-iX]

so if this is what the first module returns

Then you should be able to put Data.data into the iterator - but skip the transform to JSON.  Iterator right after the snowflake module

[D____D]

I must be doing something wrongly or that just doesn't work ... 
simple scenario

results from snowflake

iterator on {{3.Data.data}}

returns nada  

I feel like I'm really missing something simple here 

[Sven-iX]

sorry for the late response. I noticed that your {{3.Data.data}} is not solid blue. 
What does the picker show? It might be something silly like {{3.data.data}}... 

[D____D]

it's not solid blue because I hard coded the entry myself as {{3.Data.data}} ... but you have a point about it not eing solid, I'll try lower case in a bit and post here 

[Sven-iX]

You should be able to select it in the UI/picker though. 

To test, do a setvalue (or multiple) and see what you can grab from the HTTP module

[D____D]

No go ... so I've tried iterating directly from the HTTPS Query since that's already doing parse ... the get ( ) function doesn't seem to work (unless if i'm doing it wrongly which I'm okay with because it' means that there's a way) ... I've also tried my method which involved converting it the {{3.data.data}} into an array 

I can see the results correctly (assuming it is correct) 

then passing that array into the iterator ...  which the hopes that I can just say return item 4

but when I look at the iteration ... what's odd is that nothing ends up in the Value section .. all the arrays appear "outside" the value ..something I haven't seen before which tells me that I'm probably doing something wrongly ... just not sure what 

[Sven-iX]

can you click on the filter just after the HTTP module and show what it displays from the module

[D____D]

that's empty 

[Sven-iX]

Of course. Please click into one of the condition fields and screencap what pops up

[D____D]

Sure ... 

[Sven-iX]

weird that looks different from how the output bundle is described. 
Can you try putting the [1][] array into an iterator? Not by typing but by clicking it when you open the iterator

[D____D]

IKR - that's what I said! LOL  
Yea, I have never seen it pull the data like that before ... I'm starting to wonder if it's some kind of bug with OAuth2.0 Module ...or again just how I'm doing it. I had actually tried that some time ago .. 

but always ended up getting this ... 

[Sven-iX]

Omg this is getting personal  
we could try not having the HTTP module parse it, and letting you parse the data? 

Sorry - I don't have snowflake otherwise I'd try myself instead of guessing

[D____D]

You can set up Snowflake for a 30-day trial, and I understand how you feel. 

I'm submitting a ticket to Adobe because I'm leaning on the side of "this shouldn't be this hard or work this way."  

I do appreciate your efforts and ideas!! If they provide a solution, I'll post it here.

[Sven-iX]

Hey - if you're game - can you do this: 

1. Turn off parsing in the HTTP module
2. send me the module output 
   

I'm not enough of a dev to make my 30days with snowflake useful  

[D____D]

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

[Sven-iX]

Bloody heck that's some serious gymnastics to get at the data you need. 
I'm still interested in noodling on this myself - if you DM me the raw HTTP output - but I understand if you'd rather not. 

Glad you got it working!