Hi! I'm struggling to get 'lookup' with 'csvfile' in combination with 'with_items' to work.
I have this csv file (shortened snippet): "col1","col2" 1,"Mike" 2,"Sally" Than I also have this var: test_ids: - 1 - 2 Now I want to lookup (docs: https://docs.ansible.com/playbooks_lookups.html#the-csv-file-lookup) the values in the second column of the csv file: - name: read from csv file debug: msg="{{ lookup('csvfile', 'item file=/path/to/file.csv delimiter=, col=1') }}" with_items: test_ids Where 'item' before file=/... should output 1 and 2 right?? This doesn't work, output is: TASK: [client-setup | read from csv file] ******** ok: [localhost] => (item=1) => { "item": 1, "msg": "[]" } ok: [localhost] => (item=2) => { "item": 2, "msg": "[]" } As you can see it recognizes 1 and 2, but I don't get the values of the second column in the csv. If I hardcode the number in like so: - name: read from csv file debug: msg="{{ lookup('csvfile', '1 file=test.csv delimiter=, col=1') }}" with_items: test_ids It does give me the correct result: TASK: [client-setup | read from csv file] ******** ok: [localhost] => (item=1) => { "item": 1, "msg": "Mike" } ok: [localhost] => (item=2) => { "item": 2, "msg": "Mike" } I tried quoting the var with '1' and '2', but that doesn't work either. Is this a bug or am I doing something wrong? -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/4d6c6057-b0a5-4ed4-91f1-ac179f99655f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
