API v1 1:1 Nat update all previous entries .. add gives No such Function supported

EnchaCloud
New here

API v1 1:1 Nat update all previous entries .. add gives No such Function supported

Trying to allow users to request a public IP address and then map it to private DHCP address.

The problem is that i can update  but that deletes all previous entries. Using add i get  No such function supported 

 

the code is below 

import csv
from datetime import datetime
import os
import meraki
# Either input your API key below by uncommenting line 10 and changing line 16 to api_key=API_KEY,
# or set an environment variable (preferred) to define your API key. The former is insecure and not recommended.
# For example, in Linux/macOS:  export MERAKI_DASHBOARD_API_KEY=XXXXXXXX
# API_KEY = 'XXXXXXXX'


def main():
    # Instantiate a Meraki dashboard API session
    dashboard = meraki.DashboardAPI(
        #api_key='XXXXXXX',

      #  api_key='XXXXXXX',   //sandbox
        api_key= 'XXXXXXX',
        base_url='https://api.meraki.com/api/v1/',
        output_log=True,
        log_file_prefix=os.path.basename(__file__)[:-3],
        log_path='',
        print_console=False
    )

    # Get list of organizations to which API key has access
    organizations = dashboard.organizations.getOrganizations()
    print(organizations)
    # Iterate through list of orgs
    for org in organizations:
        print(f'\nAnalyzing organization {org["name"]}:')
        org_id = org['id']
        # Get list of networks in organization
        try:
            networks = dashboard.organizations.getOrganizationNetworks(org_id)
            print(networks)
        except meraki.APIError as e:
            print(f'Meraki API error: {e}')
            print(f'status code = {e.status}')
            print(f'reason = {e.reason}')
            print(f'error = {e.message}')
            continue
        except Exception as e:
            print(f'some other error: {e}')
            continue

        # Create local folder
        todays_date = f'{datetime.now():%Y-%m-%d}'
        folder_name = f'Org {org_id} clients {todays_date}'
        if folder_name not in os.listdir():
            os.mkdir(folder_name)
        # Iterate through networks
        total = len(networks)
        counter = 1
        print(
            f'  - iterating through {total} networks in organization {org_id}')
        for net in networks:
            print(
                f'Finding clients in network {net["name"]} ({counter} of {total})')
            try:
                # Get list of clients on network, filtering on timespan of last 14 days
                clients = dashboard.networks.getNetworkClients(
                    net['id'], timespan=60*60*24*14, perPage=1000, total_pages='all')
            except meraki.APIError as e:
                print(f'Meraki API error: {e}')
                print(f'status code = {e.status}')
                print(f'reason = {e.reason}')
                print(f'error = {e.message}')
            except Exception as e:
                print(f'some other error: {e}')
            else:
                if clients:
                    # Write to file
                    file_name = f'{net["name"]}.csv'
                    output_file = open(
                        f'{folder_name}/{file_name}', mode='w', newline='\n')
                    field_names = clients[0].keys()
                    csv_writer = csv.DictWriter(output_file, field_names, delimiter=',', quotechar='"',
                                                quoting=csv.QUOTE_ALL)
                    csv_writer.writeheader()
                    csv_writer.writerows(clients)
                    output_file.close()
                    print(f'  - found {len(clients)}')
            counter += 1

            print(f'Finding Network Appliance Firewall One To One Nat Rules')
            try:
                # Get list of clients on network, filtering on timespan of last 14 days
                networkOneToOne = dashboard.appliance.getNetworkApplianceFirewallOneToOneNatRules(
                    net['id'])
            except meraki.APIError as e:
                print(f'Meraki API error: {e}')
                print(f'status code = {e.status}')
                print(f'reason = {e.reason}')
                print(f'error = {e.message}')
            except Exception as e:
                print(f'some other error: {e}')
            else:
                print(networkOneToOne)

            print(f'Updating Network Appliance Firewall One To One Nat Rules')
            try:

                value = [{'name': 'Dummy',
                          'lanIp': '10.0.0.249',
                          'publicIp': '196.223.61.181',
                          'uplink': 'internet1',
                          'allowedInbound': [{'protocol': 'tcp',
                                              'destinationPorts': ["22",
                                                                   "80",
                                                                   "81",
                                                                   "443"],
                                              'allowedIps': ["any"]},
                                             ]}]
                # Get list of clients on network, filtering on timespan of last 14 days
                updatenetworkOneToOne = dashboard.appliance.updateNetworkApplianceFirewallOneToOneNatRules(
                    net['id'], value)
            except meraki.APIError as e:
                print(f'Meraki API error: {e}')
                print(f'status code = {e.status}')
                print(f'reason = {e.reason}')
                print(f'error = {e.message}')
            except Exception as e:
                print(f'some other error: {e}')
            else:
                print(updatenetworkOneToOne)

        ## Stitch together one consolidated CSV per org#
        # output_file = open(f'{folder_name}.csv', mode='w', newline='\n')
        # field_names = ['id', 'mac', 'description', 'ip', 'ip6', 'ip6Local', 'user', 'firstSeen', 'lastSeen', 'manufacturer', 'os', 'recentDeviceSerial',
        #                'recentDeviceName', 'recentDeviceMac', 'ssid', 'vlan', 'switchport', 'usage', 'status', 'notes', 'smInstalled', 'groupPolicy8021x']
        # field_names.insert(0, "Network Name")
        # field_names.insert(1, "Network ID")

        # csv_writer = csv.DictWriter(
        #     output_file, field_names, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)
        # csv_writer.writeheader()
        # for net in networks:
        #     file_name = f'{net["name"]}.csv'
        #     if file_name in os.listdir(folder_name):
        #         with open(f'{folder_name}/{file_name}') as input_file:
        #             csv_reader = csv.DictReader(
        #                 input_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)
        #             next(csv_reader)
        #             for row in csv_reader:
        #                 row['Network Name'] = net['name']
        #                 row['Network ID'] = net['id']
        #                 csv_writer.writerow(row)

# if _name_ == '__main__':


start_time = datetime.now()
main()
end_time = datetime.now()
print(f'\nScript complete, total runtime {end_time - start_time}')


# def getOrganizationNetworks(apiKey, organizationId, query=None):
#     url = "/organizations/" + str(organizationId) + "/networks"
#     success, errors, headers, response = merakiRequest(apiKey, "get", url, p_queryItems=query, p_verbose=FLAG_REQUEST_VERBOSE)
#     return success, errors, response

 

2 REPLIES 2
RaphaelL
Head in the Cloud

Hi , 

 

You cannot ''append'' an entry , you have to push all the configs + your new entry. I'm not sure if that was your question.

EnchaCloud
New here

Thank you was hoping that there would be append will have to go with this for now  

Get notified when there are additional replies to this discussion.
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.