Community
  • infoblox:blogs/category
2019-05-29T18:41:41
7 minutes

Importing a CSV file into an EA list using Postman

Many customers do not have access to python scripts and this makes it difficult to import CSV files. Learn how you can use Postman in order to import CSV files.

On this page

The Brief

I have a customer that did not have access to run a Python Script so I came up with the idea of using Postman to do it. The list of values was in the form of a CSV file.

Create an EA in NIOS

Log into your NIOS box and create an EA with the name of “Names” type of List and add a value “Testvalue”

Install Postman

Go to https://www.getpostman.com download it for your OS and follow there install guide

Get EA “_ref” from Infoblox

We are going to use “Postman” to make an API call my Infoblox appliance to call an Extensible Attributes called “Names” which is a list.

Here are a few screenshots on how to configure “Postman” to get the EA “_ref”

Make sure SSL certificate verification is turned off in Postman settings or preferences.

    1. For “Headers” we need to add Key “Content-Type” value “application/json”
    2. For “Headers” we need to add Key “Content-Type” value “application/json”
      1. For the Body select “raw” and make sure “JSON(application/json) and value {“name”:“Names”}
    3. For the Body select “raw” and make sure “JSON(application/json)
      1. Now we hit “Send” and get the results the data we are looking for is the “_ref” value “extensibleattributedef/b25lLmV4dGVuc2libGVfYXR0cmlidXRlc19kZWYkLk5hbWVz:Names” we will use this in our next “Postman” call

Convert CSV to JSON

Update the EA using “_ref”

So now we are the “_ref” for the EA:Names and the data formatted into JSON we will make a PUT call using “Postman”

Appendix:

Postman Collection have been added download under Attachments rename it to json- Thanks to Chad Willard

infoblox stuff.postman_collection.txt ‏5 KB

Article Tags
  • infoblox:blogs/tags/dns-threat-intelligence
  • infoblox:blogs
You might also be interested in