c# - Azure REST API - Create, through programming, a database within an elasticPoll -


i need create, through programming, database in elasticpoll.

to this, i'm using api version 2014-04-01, indicated in "azure rest apis > sql database > databases > create or update".

i create new httpwebrequest object , launch .create() method

httpwebrequest request = (httpwebrequest)httpwebrequest.create(string.format("https://management.azure.com/subscriptions/{0}/resourcegroups/{1}/providers/microsoft.sql/servers/{2}/databases/{3}?api-version={4}", variabiliglobali.subscriptionid, variabiliglobali.resourcegroup, variabiliglobali.sqlservername, databasename, variabiliglobali.apiversion));

and compile properties:

request.headers["authorization"] = "bearer" + token; request.contenttype = "application/json; charset = utf-8"; request.method = "put"

i create new streamwriter object

using (var streamwriter = new streamwriter(request.getrequeststream()))         {             streamwriter.write(json);             streamwriter.flush();             //streamwriter.close();         }

and .write() mothod parameter, assign complete json code of model shown in "databases - create or update" example below.

            string json =             "{" +    "\"parameters\": {" +         "\"subscriptionid\": \"" + variabiliglobali.subscriptionid + "\"," +         "\"resourcegroupname\": \"" + variabiliglobali.resourcegroup + "\"," +         "\"servername\": \"" + variabiliglobali.sqlservername + "\"," +         "\"databasename\": \"" + databasename + "\"," +         "\"api-version\": \"" + variabiliglobali.apiversion + "\"," +         "\"parameters\": {" +                     "\"properties\": {" +                 "\"elasticpoolname\": \"" + elasticpoolname + "\"" +              "}," +                     "\"location\": \"west europe\"" +          "}" +         "}," + "\"responses\": {" +             "\"200\": {" +                 "\"body\": {" +                     "\"id\": \"/subscriptions/" + variabiliglobali.subscriptionid + "/resourcegroups/" + variabiliglobali.resourcegroup + "/providers/microsoft.sql/servers/" + variabiliglobali.sqlservername + "/databases/" + databasename + "\"," +             "\"name\": \"" + databasename + "\"," +             "\"type\": \"microsoft.sql/servers/databases\"," +             "\"location\": \"west europe\"," +             "\"kind\": \"v12.0,user\"," +             "\"properties\": {" +                         "\"edition\": \"standard\"," +                 "\"status\": \"online\"," +             "\"servicelevelobjective\": \"s0\"," +             "\"collation\": \"sql_latin1_general_cp1_ci_as\"," +             "\"creationdate\": \"2017-02-24t22:39:46.547z\"," +             "\"maxsizebytes\": \"268435456000\"," +             "\"currentserviceobjectiveid\": \"f1173c43-91bd-4aaa-973c-54e79e15235b\"," +             "\"requestedserviceobjectiveid\": \"f1173c43-91bd-4aaa-973c-54e79e15235b\"," +             "\"requestedserviceobjectivename\": \"s0\"," +             "\"samplename\": null," +             "\"defaultsecondarylocation\": \"japan west\"," +             "\"earliestrestoredate\": \"2017-02-10t01:52:52.923z\"," +             "\"elasticpoolname\": null," +             "\"containmentstate\": 2," +             "\"readscale\": \"disabled\"," +             "\"failovergroupid\": null" +              "}" +                 "}" +             "}," +     "\"201\": {" +                 "\"body\": {" +                     "\"id\": \"/subscriptions/" + variabiliglobali.subscriptionid + "/resourcegroups/" + variabiliglobali.resourcegroup + "/providers/microsoft.sql/servers/" + variabiliglobali.sqlservername + "/databases/" + databasename + "\"," +             "\"name\": \"" + databasename + "\"," +             "\"type\": \"microsoft.sql/servers/databases\"," +             "\"location\": \"west europe\"," +             "\"kind\": \"v12.0,user\"," +             "\"properties\": {" +                                 "\"edition\": \"standard\"," +                     "\"status\": \"online\"," +                     "\"servicelevelobjective\": \"s0\"," +                     "\"collation\": \"sql_latin1_general_cp1_ci_as\"," +                     "\"creationdate\": \"2017-02-24t22:39:46.547z\"," +                     "\"maxsizebytes\": \"268435456000\"," +                     "\"currentserviceobjectiveid\": \"f1173c43-91bd-4aaa-973c-54e79e15235b\"," +                     "\"requestedserviceobjectiveid\": \"f1173c43-91bd-4aaa-973c-54e79e15235b\"," +                     "\"requestedserviceobjectivename\": \"s0\"," +                     "\"samplename\": null," +                     "\"defaultsecondarylocation\": \"japan west\"," +                     "\"earliestrestoredate\": \"2017-02-10t01:52:52.923z\"," +                     "\"elasticpoolname\": null," +                     "\"containmentstate\": 2," +                     "\"readscale\": \"disabled\"," +                     "\"failovergroupid\": null" +                  "}" +                 "}" +             "}," +     "\"202\": { }" +         "}" +     "}";

launch .getresponse() method of httpwebrequest object

var httpresponse = (httpwebresponse)request.getresponse();

and in response following error:

{'error': {"code": "invalidrequestcontent", "message": "the request content invalid , not deserialized: 'could not find member' parameters on object of type 'resourcedefinition' , line 1, position 14. '. "}}

where wrong?

thanks in advance.

i believe documentation incorrect. correct request payload should be:

{"properties": {"elasticpoolname": "xxxxx"},"location": "west europe"}

Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more