Forum Discussion

Brad_Baker's avatar
Brad_Baker
Icon for Cirrus rankCirrus
Nov 27, 2023

Modifying multiple entries in a datagroup via api?

We have a datagroup with entries like this:   domain1.com := virtual /Common/www.domain1.com_vs_443 domain2.com := virtual /Common/www.domain2.com_vs_443 domain3.com := virtual /Common/www.domain3...
api
datagroup
devops
TMSH
  • Sebastiansierra's avatar
    Sebastiansierra
    Nov 27, 2023

    Hi Brad_Baker

    You can additionally edit the content for a specific register

    curl -ku "admin:Logi-123" -X PATCH -H 'Content-type: application/json' -d '{ "name":"test_domain" }' https://localhost/mgmt/tm/ltm/data-group/internal/test_domain?options=records%20modify%20%7B%20key3%20%7B%20data%20ke3new%20%7D%20%7D|jq .

    as tmos you can use all of this option to interact with the data-groups

    add      delete      modify     none        replace-all-with

     to avoid mistakes use a tool to encode and decode the URL. 

Sebastiansierra's avatar
Sebastiansierra
Icon for MVP rankMVP
Nov 27, 2023

Hi Brad_Baker,

The easiest way is to delete all the content of the datagroup and then add the new records, for delete all the records use this curl:

curl -ku "admin:admin" -X PATCH 'https://192.168.30.10/mgmt/tm/ltm/data-group/internal/test_domain' --header 'Content-Type: application/json' --data '{ "records": []}'

To add the new records in only one call you can use this curl:

curl -ku "admin:admin" -X PATCH 'https://192.168.30.1/mgmt/tm/ltm/data-group/internal/test_domain' --header 'Content-Type: application/json' --data '{"records": [{"name": "domain1.com","data": "virtual /Common/maintenance.domain1.com_vs_443"},{"name": "domain2.com","data": "virtual /Common/maintenance.domain2.com_vs_443"},{"name": "domain3.com","data": "virtual /Common/maintenance.domain3.com_vs_443"}]}'

Hope it works.

 

 

  • Brad_Baker's avatar
    Brad_Baker
    Icon for Cirrus rankCirrus
    Nov 27, 2023

    Hey Sebastiansierra thanks for the response and suggestions.

    Unfortunately, the recommendation above won't accomplish what I am trying to do.

    I have approximately 100-150 entries in my datagroup. When I run the command recommended above: 

    curl -ku "admin:admin" -X PATCH 'https://192.168.30.1/mgmt/tm/ltm/data-group/internal/test_domain' --header 'Content-Type: application/json' --data '{"records": [{"name": "domain1.com","data": "virtual /Common/maintenance.domain1.com_vs_443"},{"name": "domain2.com","data": "virtual /Common/maintenance.domain2.com_vs_443"},{"name": "domain3.com","data": "virtual /Common/maintenance.domain3.com_vs_443"}]}'

    It replaces all 100-150 entries with the 4 entries in the data section.

    I don't want to delete existing entries; I only want to edit specific records. So I'm looking to do a targeted modification to only touch the records that need changing and leave the rest alone.

    Also, I understand I could do a GET to get all records, use a regex to replace just what I want to replace, and then do a PUT/PATCH to send the modified version back.

    But that hinges on getting a regex exactly right. If my regex matches wrong (i.e. too much) I could accidentally edit the wrong record. It just seems a bit risky to do it using regex/pattern matching. Thus wanting a targeted approach that edits specific records.

    Is that possible or does the F5 api just not support that?