[cPanel UAPI] How to get the serial of a DNS zone

[Anindya Sundar Mandal]

Hello,

I want to set DNS TXT records with cPanel UAPI from a PHP application. Authentication is done with API Tokens. So I was reading this documentation: Update a DNS zone.

A request sample as per docs:

https://hostname.example.com:2083/cpsess##########/execute/DNS/mass_edit_zone?zone=example.com&serial=202001010100&remove=23

'serial' is a required parameter.

How can I get the serial of a DNS zone using UAPI? I have not found this in the documentation.

Thank you.

 

[cPRex]

Hey there! I reached out to the team and there is not an API call available that will provide the serial number. Most people use a grep/awk combination to pull that information manually.

If you'd like to see us add this, could you use the link in my signature to submit a feature request and I'll make sure the development team approves that?

 

[Anindya Sundar Mandal]

I have submitted the feature request: https://features.cpanel.net/topic/2...-will-provide-the-serial-number-of-a-dns-zone

Please update here once it is done and published.

Thank you.

 

[cPRex]

Thanks for submitting that. It's up to the team to decide if they want to add it, but I'll be sure to bring it up during next weeks' features meeting.

 

[santrix]

Maybe I'm missing something here, but you can just use whmapi1 dumpzone, then look through the .data -> zone[0] -> record objects for type == 'SOA', then you will find serial in there as a key/value. Or rip it out directly e.g. perl

perl -0777 -ne 'if ($_ =~ m/^([^;][^\n]+\bSOA\b.*?)(\b[0-9]+)/ms){ if ($2 =~ m/([0-9]+)/){print "$ARGV:$1\n"}}' /var/named/domain.db

 

[RadWebHosting]

Maybe I'm missing something here, but you can just use whmapi1 dumpzone, then look through the .data -> zone[0] -> record objects for type == 'SOA', then you will find serial in there as a key/value. Or rip it out directly e.g. perl

perl -0777 -ne 'if ($_ =~ m/^([^;][^\n]+\bSOA\b.*?)(\b[0-9]+)/ms){ if ($2 =~ m/([0-9]+)/){print "$ARGV:$1\n"}}' /var/named/domain.db

Yeah, I am unclear as to what benefit the UAPI would give since your method could easily be iterated/scaled. Maybe OP can enlighten us.

 

[gonzadiaz]

Hi, i had that problem that i needed the serial number to use the update zone API. After some investigation i got here and tried the perl script solution. But after sometime experimenting i have found a better way.
Using the "parse_zone" api i get all dns records. Filtering the SOA registry i found in the data field the serial number. The SOA registry has 6 strings inside data_b64 array, the third value in the array is the serial number.