MIIC Bulk Query
Provider organizations that need to query for large groups of Minnesota Immunization Information Connection (MIIC) client data may find it helpful to use our Bulk Query process. This process involves an organization creating a list of clients and loading the list to the Minnesota Department of Health (MDH) CloudDrive site. The list is then matched to clients in MIIC, and their immunization histories are returned to the requesting organization. Input and output files are both | (pipe character) delimited .txt files.
Getting started
First check internally to see if your organization is already set up to exchange large volumes of data with MIIC using the Bulk Query via CloudDrive process. If it is not, email the MIIC Help Desk and let them know you are looking to use Bulk Query to get MIIC data. MIIC staff will verify whether your organization has a current Data Use Agreement (DUA) on file. If your organization is new to MIIC, visit Enroll in MIIC.
Creating the query file
Work with your system's vendor or IT team to pull data in a | delimited format found in the plain text notepad example file (txt). The header row (row 1) must be present and column headers must be in all lowercase letters with underscores instead of spaces. The client's information should be filled in beginning on row 2 of the file. The input file should contain one row for each person that you want data on. The minimum required fields are: First Name, Last Name, and Date of Birth. The remaining columns are optional. Providing additional demographic information can assist with the matching process.
The file must be saved as a | delimited .txt file. The file name must not include any spaces. Underscores are acceptable.
Uploading the query file and downloading the response file
Sending your query file and retrieving the results are done via CloudDrive. MIIC staff will work with you to give you access to CloudDrive and ensure your credentials are set up and working properly. CloudDrive is an MDH site that puts your file directly into an S3 bucket. This allows for immediate exposure to other AWS services, principally Lambda. This will kick off processing your file automatically and will alert you to the status of your file via email.
Once processing is done, you will need to log back into CloudDrive to retrieve your response file. The outbound file will contain 1 row for each vaccination event on any matched person's record.
