# Load the dictations between the start and end date into a pandas dataframe.
# Then write the data to a csv file.
	
import requests
import json
import pandas as pd

#set parameters below. Server options are test.nvoq.com & healthcare.nvoq.com
#########################################
server = "test.nvoq.com"
username = "YOUR_USERNAME"
password = "YOUR_PASSWORD"
startDay = "01-01-2024"
endDay = "01-31-2024"
#########################################

headers = {"Accept":"application/json"}
params = {"includeDeleted":"false"}

#get the top level org in the hierarchy
getOrgString =  "https://"+server+"/SCVmcServices/rest/organizations"
r = requests.get(getOrgString, params=params, headers=headers,auth=(username,password))
orgs = r.json()
orgId=orgs['id']

#download the dictations
dictationsDF = pd.DataFrame()
print ("downloading transactions...")
resultLimit = 3000
startResult = 0
returnCount = resultLimit
    
#page our way through downloading the data and add it to the dataframe
while returnCount >= resultLimit:
    requestString = "https://"+ server + "/SCVmcServices/rest/transactions"
      params = {"startDate":startDay+" 00:00:00 -0600","endDate":endDay+" 23:59:59 -0600","resultLimit":str(resultLimit), "startResult":str(startResult),"itemType":"dictation"}
    r = requests.get(requestString, params=params, headers=headers,auth=(username,password))
    jsondata = json.loads(r.text)
    df = pd.json_normalize(jsondata)
    returnCount = len(df.index)
    startResult = startResult + resultLimit
    print ("downloaded batch of " + str(returnCount) + " ...")
    if (returnCount != 0):
        #if this is the first set of data, use initialized empty dataframe
        if len(dictationsDF.index) == 0:
            dictationsDF = df
        #otherwise append the newly downloaded data
        else:
            frames = [dictationsDF, df]
            dictationsDF = pd.concat(frames)

print ("Total Dictations Downloaded: " + str(len(dictationsDF.index)))
dictationsDF.to_csv("nVoqDictationExport-"+startDay+"-"+endDay+".csv")
  

import java.io.*;

//...

public class Program {

   //...

   /*
    *  Get all the transactions between start date/time and end date/time
    *  using a specific page size for the request processing.
    */
   private void getTransactions(String aStartDate, String aEndDate, int aPageSize) {

      // Pagination -->
      // Start with item 0 and increment by page size for 
      // subsequent requests.  For example, with a page size of 10,
      // request startResult 0 which returns 0-9, then start result 10
      // which returns 10-19, and so on.  The last page with have <= 10
      // items. When the query returns 0 items, you have reached the end.
      int startResult = 0;
      int returnedResults = Integer.MAX_VALUE;
      
      while (returnedResults > 0) {

         String url = baseUrl + "/SCVmcServices/rest/transactions";

         // query method parameters
         // dates are of the form MM-dd-yyyy, MM-dd-yyyy HH:mm:ss, 
         // or MM-dd-yyyy HH:mm:ss Z
         Map<String, String> myParams = new HashMap<String, String>();
         myParams.put("startDate", aStartDate);
         myParams.put("endDate", aEndDate);
         myParams.put("resultLimit", Integer.toString(aPageSize));
         myParams.put("startResult", Integer.toString(startResult));
         //increment start result for requesting the next batch
         startResult = startResult + aPageSize;
         
         //create a query string to use with our request
         String qString = createQueryString(myParams);

         try {
            StringBuffer sb = httpHelper("GET", url, qString);
            JSONParser jsonParser = new JSONParser();
            Object obj = jsonParser.parse(sb.toString());
            JSONArray xactArray = (JSONArray) obj;
            returnedResults = xactArray.size();
            xactArray.forEach((xact) -> myTransactions.add(new Transaction(xact.toString())));
         } catch (Exception e) {
            System.out.println(e.toString());
         }
      }
   }

   
   //...
}
 

<script>
//TBD
</script>
  
  

using Newtonsoft.Json;

//...

namespace nVoqHttpApiCSharp
{
    class Program
    {

        //...
        /**
        *  Get all the transactions between start date/time and end date/time
        *  using a specific page size for the request processing.
        */
        private static List<Transaction> getTransactions(String aStartDate, String aEndDate, int aPageSize)
        {
            // Pagination -->
            // Start with item 0 and increment by page size for 
            // subsequent requests.  For example, with a page size of 10,
            // request startResult 0 which returns 0-9, then start result 10
            // which returns 10-19, and so on.  The last page with have <= 10
            // items. When the query returns 0 items, you have reached the end.
            int startResult = 0;
            int returnedResults = int.MaxValue;
            List<Transaction> transactions = new List<Transaction>();

            while (returnedResults > 0)
            {

                // query method parameters
                // dates are of the form MM-dd-yyyy, MM-dd-yyyy HH:mm:ss, 
                // or MM-dd-yyyy HH:mm:ss Z
                SortedDictionary<string, string> queryParams = new SortedDictionary<string, string>();
                queryParams.Add("startDate", aStartDate);
                queryParams.Add("endDate", aEndDate);
                queryParams.Add("resultLimit", aPageSize.ToString());
                queryParams.Add("startResult", startResult.ToString());
                startResult = startResult + aPageSize;
                String queryString = createQueryString(queryParams);
                String url = BaseUrl + "/SCVmcServices/rest/transactions";
                url = url + "?" + queryString;
                Console.WriteLine(url);
                List<Transaction> batch = JsonConvert.DeserializeObject<List<Transaction>>(httpHelper("GET", url, null));
                returnedResults = batch.Count;
                if (returnedResults > 0)
                {
                    transactions.AddRange(batch);
                }
            }
            return transactions;
        }