Reply

Use WAPI to find all records with part of name in search and export to CSV?

[ Edited ]
Authority
Posts: 12
6279     0

Due to the limit of 500 records in GUI and 1000 records in WAPI call, I could really use some help to search for what I'm looking for which is every record (PTR, A-Record, etc) that has wnw7 included and export details so I can create a CSV for implementers to implement during scheduled change.

 

I have tried

https://GridMasterIP/wapi/v2.9.7/record:ptr?_return_type=json-pretty&view=Internal

(doesn't give just records with wnw7 and trying to parse through this is a mess)

 

Any help is appreciated.

Re: Use WAPI to find all records with part of name in search and export to CSV?

Superuser
Posts: 115
6280     0

Here you go

 

https://GridMasterIP/wapi/v2.9.7/record:ptr??ptrdname~=wnw7&_return_type=json-pretty&view=Internal

 For future, you can also check out my site https://sifbaksh.com 

 

Let me know if you have any questions

Follow me on LinkedIn: https://www.linkedin.com/in/sifbaksh
Twitter: https://twitter.com/sifbaksh

https://sifbaksh.com

Re: Use WAPI to find all records with part of name in search and export to CSV?

Techie
Posts: 12
6280     0

It may be worth mentioning that the WAPI is not limited to 1000 records if you set _max_results and _paging.

 

e.g.

https://{{grid_master}}/wapi/v2.10.5/network?_max_results=1000&_paging=1&_return_as_object=1

Re: Use WAPI to find all records with part of name in search and export to CSV?

Techie
Posts: 12
6280     0

Hello Sif,

I'm getting the following error:

 

    "Error""AdmConProtoError: Invalid input: '?ptrdname~'",
    "code""Client.Ibap.Proto",
    "text""Invalid input: '?ptrdname~'"
 
I fixed it by removing one of the "?" --> ptr?ptrdname
 
 

Re: Use WAPI to find all records with part of name in search and export to CSV?

Superuser
Posts: 115
6280     0

Good catch

Follow me on LinkedIn: https://www.linkedin.com/in/sifbaksh
Twitter: https://twitter.com/sifbaksh

https://sifbaksh.com
Showing results for 
Search instead for 
Did you mean: 

Recommended for You

NIOS 8.6.3 – What’s New in DDI