Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-1720

error when calling api to create phone number for CoPersonRole

    XMLWordPrintable

Details

    Description

      POST-ing to /telephone_numbers.json:

      {
          "RequestType":"TelephoneNumbers",
          "Version":"1.0",
          "TelephoneNumbers":
          [
              {
                  "Version":"1.0",
                  "Number": "1234567890",
                  "Description":"work phone",
                  "Person":
                  {
                      "Type": "CoRole",
                      "Id": <a CoPersonRole.Id>
                  }
              }
          ]
      } 

      Getting result:

      comanage          | 2019-03-27 22:17:08 Error: [PDOException] SQLSTATE[42703]: Undefined column: 7 ERROR:  column CoPersonRole.co_id does not exist
      comanage          | LINE 1: SELECT "CoPersonRole"."co_id" AS "CoPersonRole__co_id" FROM ...
      comanage          |                ^
      comanage          | HINT:  Perhaps you meant to reference the column "CoPersonRole.cou_id".
      comanage          | Request URL: /registry/telephone_numbers.json
      comanage          | Stack Trace:
      comanage          | #0 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(489): PDOStatement->execute(Array)
      comanage          | #1 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(455): DboSource->_execute('SELECT "CoPerso...', Array)
      comanage          | #2 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(702): DboSource->execute('SELECT "CoPerso...', Array, Array)
      comanage          | #3 /srv/comanage-registry/lib/Cake/Model/Datasource/DboSource.php(1213): DboSource->fetchAll('SELECT "CoPerso...', Array)
      comanage          | #4 /srv/comanage-registry/lib/Cake/Model/Model.php(3040): DboSource->read(Object(CoPersonRole), Array)
      comanage          | #5 /srv/comanage-registry/lib/Cake/Model/Model.php(3012): Model->_readDataSource('first', Array)
      comanage          | #6 /srv/comanage-registry/lib/Cake/Model/Model.php(1666): Model->find('first', Array)
      comanage          | #7 /srv/comanage-registry/app/Controller/Component/ApiComponent.php(91): Model->field('co_id', Array)
      comanage          | #8 /srv/comanage-registry/app/Controller/StandardController.php(63): ApiComponent->checkRestPost()
      comanage          | #9 [internal function]: StandardController->add()
      comanage          | #10 /srv/comanage-registry/lib/Cake/Controller/Controller.php(491): ReflectionMethod->invokeArgs(Object(TelephoneNumbersController), Array)
      comanage          | #11 /srv/comanage-registry/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction(Object(CakeRequest))
      comanage          | #12 /srv/comanage-registry/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(TelephoneNumbersController), Object(CakeRequest))
      comanage          | #13 /srv/comanage-registry/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
      comanage          | #14 {main}
      comanage          | 172.18.0.5 - sim [27/Mar/2019:22:17:08 +0000] "POST /registry/telephone_numbers.json HTTP/1.1" 500 2260 "-" "python-requests/2.19.1" 

       

      Attachments

        Activity

          People

            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            gtorok Gabor Torok (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: