Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    SQL Fehlermeldung bei API "cmdb.condition.read"

    Scheduled Pinned Locked Moved Unsolved Entwicklung
    1 Posts 1 Posters 8 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M Offline
      maxusmaus
      last edited by

      Moin,
      wenn ich über die API "cmdb.condition.read" ausführen möchte, kriege ich folgende Fehlermeldung:

      {
        "id": 1763477213944907450,
        "jsonrpc": "2.0",
        "error": {
          "code": -32099,
          "message": "i-doit system error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7",
          "data": null
        }
      }
      

      Mein Code

      resp = CMDB_SESSION.post(CONFIG['IDOIT_API_URL'], json={
          "version": "2.0",
          "method": "cmdb.condition.read",
          "params": {
              "language": "en",
              "apikey": CONFIG['IDOIT_API_KEY'],
              "conditions": [
                  {
                      "comparison": "like",
                      "property": "f_text_c_ipmi_dns",
                      "value": "asdf.de",
                  }
              ]
          },
          "id": time.time_ns(),
      })
      print(json.dumps(resp.json()))
      
      1 Reply Last reply Reply Quote 0
      • First post
        Last post