(March 2016: Lab updated for IIB10003) This lab shows you how to create and test a new REST API service. This scenario will be based on the EmployeeService example that you may have used in other labs in this series.

  • Lab instructions
  • Lab file (251 KB). Download this Lab file, and then extract to C:\ to create or update the folder C:\student10.

Featuring:

  • The REST API tools for IIB
  • Testing with Swagger UI

Related tutorial in the IIB V10 Integration Toolkit:

Manage a set of records with IBM Integration Bus REST API services
Learn how to use an IBM Integration Bus REST API service, based on a Swagger document, to manage a set of records.

You might also be interested in…

An IIB Demo for REST Service
A video blog post that shows how easy it is to use the Integration Toolkit to create a REST API service exposing a database table.
Pushing a REST API from IBM Integration Bus V10 into IBM API Management
A step-by-step guide shows you how easily you can push a REST API from the Integration Toolkit of IBM Integration Bus v10 to IBM API Management on Cloud.

155 comments on"[iib10] Lab 2: Developing a REST API service"

  1. Hi Ian,
    can You please tell me how to get the IIB Event Log Viewer?
    Thanks.

  2. wujun zhai May 21, 2018

    HI:
    How to fix such error:
    {
    “EmployeeResponse”: {
    “DBResp”: {
    “UserReturnCode”: 0,
    “RowsRetrieved”: 42,
    “RowsAdded”: 0,
    “RowsUpdated”: 0,
    “RowsDeleted”: 0,
    “SQLCode_ErrorCode”: 0,
    “SQLState_SQLState”: null,
    “SQL_Error_Message”: null
    },
    “EMPLOYEE”: {
    “EMPNO”: “200340”,
    “FIRSTNME”: “ROY”,
    “MIDINIT”: “R”,
    “LASTNAME”: “ALONZO”,
    “WORKDEPT”: “E21”,
    “PHONENO”: “5698”,
    “HIREDATE”: “1997-07-05”,
    “JOB”: “FIELDREP”,
    “EDLEVEL”: 16,
    “SEX”: “M”,
    “BIRTHDATE”: “1956-05-17”,
    “SALARY”: 31840,
    “BONUS”: 500,
    “COMM”: 1907
    }
    }
    }
    rowretrieves = 43
    employees = 1

    • Ian_Larner May 24, 2018

      @wujun zhai Hi,
      Thanks for the comment. Your experience is a bit unusual, so will take a bit of research. I’ve passed it on to the Betaworks team who created the Labs, and should get back to you soon.
      Regards, Ian

  3. gmadkins2 May 08, 2018

    Instructions on how to obtain the log viewer are located in the notes section at the following line –> https://developer.ibm.com/integration/docs/ibm-integration-bus/self-study-labs/

    • Ian_Larner May 09, 2018

      @gmadkins2 Hi,
      You are correct. I recently changed the process for getting the IIB Log Viewer, to avoid the need for people to register. It was thought best to just let people download the files “as is”.
      Regards, Ian

  4. anilkumarmvvs April 10, 2018

    Hi Ian,

    can you please send me the IIB Event log monitor.

    Thanks.

    • Ian_Larner April 10, 2018

      @anilkumarmvvs Hi,
      I’ve sent you an email about how to get and use the IIB Event log monitor.
      Regards, Ian

  5. Hi, can you please send me the IIB Event log monitor

    • Ian_Larner April 05, 2018

      @Madhu Hi,
      I’ve sent you an email about how to get and use the IIB Event log monitor.
      Regards,
      Ian

  6. Hello Ian,

    Could you send the IIB Log Viewer for me as well?

    Thanks in advance!

    • Ian_Larner April 04, 2018

      @LUANMF Hi,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  7. Hello Ian,
    Nice article. Can I have the details to use IIB Even log Monitor please

    • Ian_Larner April 04, 2018

      @GKG Hi,
      Thanks for the comment… which go to the IBM Betaworks team who created the labs.
      I’ve sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  8. Hi Ian! I really appreciate for the Labs.Can you please send me the IIB log viewer.

    • Ian_Larner March 29, 2018

      @Sara Hi,
      I’ve sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  9. Hi Ian

    Great lab. I’m also looking for instructions to get the IIB Log Viewer if you wouldn’t mind sending them on.

    Thanks

    • @Gerard Hi,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  10. Giovanni Mangiapanello February 16, 2018

    Hi Ian,
    thank you for your interesting lab.
    I would need the IIB Event Log Monitor exe file for IIB administration.
    Could you please sen me the link for download ?
    Many Thanks
    Giovanni

    • Hi Giovanni,
      I’ve sent you an email about how to get and use the IIB Event Log Monitor.
      Regards, Ian

  11. Hi Ian,
    thanks for your lab. Could you please provide a link to the IIB Log Viewer.

  12. Debopriya Dutta January 08, 2018

    Hi,

    I was hoping if you could show in details how do I expose the database as a web service and post the response in the database, I am a little unclear there

  13. Hi Ian,
    Thanks very much for the Labs.
    Can you please also send me the Windows Log Viewer files?
    Thanks,

    • @forres, Hi
      I’ve sent you an email about how to get and use the Log Viewer.
      Regards, Ian

      • Can you please let me know where i can get IIB Log Viewer.

        • @Alok Hi,
          I’ve sent you an email about how to get and use the IIB Log Viewer.
          Regards, Ian

          • Hi Ian,

            Thanks for your email.I just implemented LAB 2 and got 1 error.

            While changing for each connection to submap i am getting error.

            Error is like data for EmployeeNumber in Input doesnt match with output connected or vice – versa.

            In email i have supplied your with scree shot.

            Thanks
            Alok

          • Hello Ian,

            Can you please help here in resolving this error?

          • @Alok Hi,
            I’ve passed your question on to the IBM Betaworks team who created the Labs. I think its just a problem of how the mapping was created, but want them to confirm the solution. (I am not really a support person for IIB Labs, but do try to help as much as I can with time permitting.)
            Regards,
            Ian

    • Terry Hudson January 15, 2018

      Hi Deboprya,

      Thank you for your interested in our lab guides. You said “I was hoping if you could show in details how do I expose the database as a web service and post the response in the database, I am a little unclear there”

      The “Lab 2: Developing a REST API service” takes you through how you could expose the sample EMPLOYEE table as a REST API, so you can feed an employee number onto the REST API and it will respond with the EMPLOYEE details from the EMPLOYEE database, effectively exposing the content of the database as a web service.
      If you want an example of adding records to the data base, there is a HR_Service REST API implemented in our lab guides at 10.0.0.7 which includes a REST API with an example POST. To see this download the student10 file from https://ibm.biz/betaworks-iib (in the Files section). Download the student10.7z in the folder “IIB student folder (Latest Version 20th January 2017)”.

      When you have unzipped the student folder, import C:\student10\HR_complete\HR_Service\solution\HR_Service_Complete.10.0.0.7.zip into your toolkit environment. Open the REST API Description in HR_Complete and navigate to /employees/complete/multipart and open the implementation for createEmployeeFromMultipart. In the subflow createEmployeeMain the map “create_insertNewEmployeeIntoHRDB” shows a mapping node that inserts data into a database. The lab guide 2166-IC17.pdf does talk about some of the above at a high level.

      All the best
      Terry Hudson (IBM BetaWorks)

  14. can you please send me log viewer

    • @Chaitanya Hi,
      I’ve sent you an email about how to get and use the log viewer.
      Regards, Ian

  15. Hello Ian,

    Could I also have the information about the IIB log viewer please? Thanks!

    • @Giannis, Hi
      I’ve sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  16. Please send me the information on getting and using the iIB log viewer.

    Thanks

    • @syam Hi,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  17. Bala Narayanasamy October 06, 2017

    Hi Ian,

    Could you please suggest to view the log monitor?..

    Thanks
    Bala

    • @Bala Narayanasamy
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  18. Hi Ian,

    Can you please tell me how to get log viewer?

    Thanks,
    LaToya

    • @LaToya Hi,
      I’ve sent you an email about how to get and use the Log Viewer.
      Regards, Ian

  19. Alessandra July 27, 2017

    All the links doesn’t work for me.
    I’ve tried in two differents computers and lans.

  20. tarun1113 July 26, 2017

    Hi Ian,

    Its a great stuff, Thanks.

    I’ll be thankful if you can help me to get IIB Log Viewer as well.

    • @tarun1113,
      Hi Tarun, I’ve sent you an email about how to get and use the IIB Log Viewer. Regards, Ian

  21. Tarun Sharma July 26, 2017

    Hi Ian, Its a great stuff to start with.
    Can you please help me to get IIB Log Viewer?

    • Ian_Larner July 28, 2017

      Tarun,
      Thanks for the feedback. I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  22. John Ormerod July 25, 2017

    Hello Ian.
    I’d be grateful if you could send me the link to the Log Viewer.
    Regards, John

    • Ian_Larner July 25, 2017

      Hello John,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  23. emmasant88 June 07, 2017

    HI Ian_Larner
    Could you please send me the link for IIB log viewer?
    Thank you !

    • Ian_Larner June 26, 2017

      @emmasant88
      I’ve sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  24. Hi,

    In REST API, I need to add logging functionality after HTTPReply node. Since main flow is auto generated via Swagger file. So need to know, is there a way we can add logging functionality.
    I actually build logging message throughout the flow and want to put log message into Queue after HttpReply node.

  25. Hello Ian,

    Can you please send me the link for IIB log viewer?

    Thank you !

    • Ian_Larner May 22, 2017

      @David Hello,
      I have sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  26. I am writing a REST API that will call multiple REST APIs. Prior to REST APIs, we used aggregation nodes and MQ. I am looking at the REST Async nodes to replace MQ, but have a couple of questions.

    1) what are the advantages, if any of using the REST Async nodes rather than MQ.
    2) can you guarantee delivery using the REST Async nodes or must you use MQ to guarantee delivery?

    Thanks

    • ILIYA Dimitrov April 25, 2017

      Hi KHogan,

      I am sure that your would appreciate that these are two different technologies, so in general you will have to decide how are you planning to use what you develop with an outlook ahead.

      With regards to using REST nodes, and with the current trend, REST APIs are becoming a more and more useful. You can easily expose backend functionality (e.g. through a Web browser) or manage them with an API management tool;

      The REST API nodes use HTTP and the reliability will be based on the HTTP connectivity. This should be a key factor for you when deciding which technology to use. However, you can still ensure that you build an appropriate logic, which can check and verify the consistency of delivering the messages.

      I hope this helps.

      Thank you

  27. Dave Morrison April 07, 2017

    Please provide instructions on how to install IIB Event Log Monitor. I was able to complete Lab 1 without it, but it would be nice to have for subsequent labs. Thank you!

    • Ian_Larner April 10, 2017

      Hi Dave,
      I have sent you an email about how to get and use the IIB Event Log Monitor. Regards, Ian

      • ArpanKSharma April 24, 2017

        Hi Ian
        can you please share instructions on how to install IIB Event Log Monitor with IIB10?

        • Ian_Larner April 24, 2017

          Hi,
          I’ve sent you an email about how to get and use the IIB Event Log Monitor.
          Regards, Ian

  28. Hi All,
    I am not able to download these labs .

    Can anyone send me to my mailid please.I need to learn IIB ASAP.

    Please help.

    Email:diptiksh@gmail.com

  29. In the section on Testing with SOAPUI, it said to open an EmployeeService_PrebuiltWorkspace. Where do I get this prebuilt workspace? Can you send it to me? Thanks.

    • ILIYA Dimitrov March 24, 2017

      Hello Jimson,

      In the lab above – ‘Lab 2: Developing a REST API service’, the testing of the REST API is being done with Swager UI.
      Could you please specify for which lab is your inquiry?

      Thank you

  30. Karen Hogan March 03, 2017

    hello, I am trying to run this lab on my company-owned laptop on which I have just installed V10.007. it seems that this lab is expecting to be run on an IBM VM. I am not able to run a lot of the commands – am I missing something? can you steer me in the right direction, please? Thanks

    • ILIYA Dimitrov March 16, 2017

      Hi Karen,

      The labs does not require IBM VM and you should be able to run them on your own machine.
      However, you will need to ensure that the user name under you are running the labs have administrative authorities for Integration Bus and DB2. In addition, you will need to ensure the DB scripts contain your User ID.

      Similar question has been answered for Lab1, please review.

      Could you please advise which commands are failing for you, so we may be able to advise further?

      Thank you

  31. Karen Hogan March 03, 2017

    Please send me the information on getting and using the iIB log viewer.

    Thanks

    • Ian_Larner March 06, 2017

      Karen,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  32. Hi, I put it a question a couple days ago and it is still in the same state. Is there another location I need to add questions/comments to get a quicker response ?
    I have an urgent need. I would appreciate some help.

    • Hi Betty,
      Sorry for the delay. I passed your question on to the Lab providers, but have no update yet. (Also, I have not been able to investigate myself.)

      I suggest that you ask the question in the IIB dWAnswers forum, which is monitored by other IIB users and by IBM IIB folks.

      We’re following up with the Lab providers, to see if we can answer questions more quickly.

      Regards,
      Ian

  33. Hi, I followed your instructions to build the REST API, but when I put in a partial number (getEmployee by number), my query returns 17 rows, but, only one row is displayed in my output in swagger.
    Please can you let me know how I can get all 17 rows to show up. Also, any help in implementing the “Get all employees” will be appreciated.

    • ILIYA Dimitrov February 16, 2017

      Hi Betty,

      In order to have all the the rows that match partially the ’employeeNumber’ provided, you will need to implement ‘For each’ function in your ‘Select’ transformation. This should allow you to see employees which ’employeeNumber’ match part of the input number requested.
      With regards to retrieving all the employees, when you modify your Database Select (assuming you elect the EMPLOYEE column), you will need to put an ”SQL where clause’ 1=1. This will provide ‘true’ statement and when a request comes in it should retrieve all the Employees.

      I hope this helps.

      Thank you

      • Thanks for your response Iliya. My question on the partial match was, that 17 rows were being returned. I add a file output node just before the end node, and I get 17 rows, but in swagger only the last record was being displayed and was misleading me.

  34. In case of employeeNumber=0020 (As in Lab 01) REST service response has only one employee (the last one) but “RowsRetrieved”: 2. Whats wrong?

    • ILIYA Dimitrov February 16, 2017

      Hi Dmitry,

      Please make sure that your map is using ‘For each’ transformation, which will ensure that all the records that match partially the input employeeNumber (‘0020’) will be retrieved and displayed.

      Thank you

  35. Hi I followed the instructions to create a REST API, but when I try to test the service by choosing to ‘Start Web User Interface’ , I get the permission error:

    The logged-on user ID does not have the required permissions ‘Start Web User Interface’ to access data or broker resources in the web user interface. See your broker administrator to set up the required permissions.

    Please let me know how to fix this.
    Thanks.

    • Hi @Crenie,
      If administration security is enabled, users can access the web user interface only when they have had appropriate permissions assigned to them (for their configured role). You need to have defined roles and their associated permissions. For more information, see https://www.ibm.com/support/knowledgecenter/en/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bn28460_.htm

      P.S. If administration security is not enabled, you access the web user interface as the default user without logging in, and you have access to all data and integration node resources.

      regards,
      Ian

  36. Hello,

    Read your Instructions and Lab work, very useful.
    However, I’m using IIB 10.0.0.3 trying to create REST Service from scratch with out swagger.
    I don’t see any option under “REST API” in toolkit to create with out swagger. It does not allow me to continue further with out specifying “Swagger” location. I’m new to swagger and dont need this for my REST service implementation with just a “POST” operation.

    Is there any documentation or link that you can refer to create REST Services for JSON with out swagger document using 10.0.0.3 toolkit version?

    Thanks

  37. Thanks very much for the Labs.
    Can you please also send me the Windows Log Viewer files?

    • Hi,
      I’ve sent you an email about how to get and use the IIB Event log monitor.
      Regards, Ian

  38. Ravi Ranjan October 25, 2016

    Hi Ian_Larner,

    I am new here. i want to learn the IIB from basics. Can U please help me from where i should have to start.

    • Hi Ravi,
      A good place to start learning IIB by trying is to download the IIB for Developers and try the tutorials, starting with the doc post Get started with IBM Integration Bus for Developers. That post has links to some videos and blog posts to help initial understanding, and to the tutorials and patterns that you can use to help develop IIB solutions and learn along the way.

      In this community there are other useful resources to help you learn IIB, IIB on Cloud, and other IIB uses. Have a look under Resources and the Blog posts for IIB (you can use tags to select subjects of interest), see Blog.

      If you want to read more about the basics of IIB and specific subjects/features, you might like to try Start here in the IIB V10 product documentation.

      If you are more into videos, have a look at videos in the IBM Integration Media channel in Youtube, such as A hands-on overview of IBM Integration Bus V10, from installing to exploring an integration solution.

      As you get going with IIB, you might also like to browse the questions and answers in the IIB forum on dWAnswers, which is a good place to ask your own questions and interact with other IIB users and IIB experts from IBM.

      After getting started, you also might like to revisit these self-study Labs, which provide more-comprehensive learning experiences that go beyond the basics.

      I hope that these suggestions help. Keep in touch through this community and/or the dWAnswers forum.

      Regards,
      Ian

  39. Hello Ian,
    Can you please send me the link for IIB log viewer. I want to try the lab exercise.

    • Hi Veerababu,
      I’ve sent you an email about how to get and use the IIB log viewer. Regards, Ian

  40. Rajinikanth Ravikumar September 30, 2016

    Can you please also send me the Windows Log Viewer files?

    • Hi,
      I’ve sent you an email about how to get and use the IIB Log Viewer
      Regards, Ian

  41. LuisFelipeBertel September 29, 2016

    Hello Ian,
    Hope your doing well.

    This tutorial helped me to develop a REST Service at IIB 10.0.0.6, so far everything is working fine. Right now it’s time to push for a testing environment, since our rest service interacts with DB2 database was necessary to create a Database project along with it and set the JDBC/ODBC credentials for the mapping/esql nodes in it.

    I’ve been looking for information about best practices related staging from DEV to PROD, but haven’t found much information about it. Also database team mention that each environment has different database name.

    According to this article, the database definition file created to use the mapping node uses the DB name and the name of the JDBCProvider services must be identical to the name of the database, that makes me wonder what should i do in this case when our databases name are different in each environment? Any advice ?
    http://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/cm28825_.htm

    Regards,

  42. Nicolas_Echavarria September 22, 2016

    Ian,

    Can you please send me the URL to download the Windows Log Monitor for IIB?
    Thanks a lot!

    Nicolas E.

    • Nicolas,
      I’ve sent you an email about how to get and use the IIB Log Monitor.
      Regards, Ian

  43. Hi all!
    Can anyone suggest the most efficient way to debug/test workflow and, most important – testing schema’s? Or everyone just blindly follow labs instructions, hoping they’ll gonna work? I can’t get why so huge labs set does not contain debugging exercise? I’m stuck with the error I described below and it now obvious why no one have a clue what’s going on. Asking on the forum is not an option as well, it seems to be dead.

    • Alex,
      Apologies for not replying earlier. I passed your comment onto the IBM Betaworks team who created the Labs, as they are best placed to respond to specific comments. They’re currently committed on immediate project commitments, but should respond in due course.

      In general, IBM Integration Bus provides a range of ways to debug/test flows. Lab 1 provides an introductory use of the Flow Exerciser, a useful for testing flows, and is used by some other Labs too. Other debug/test aids are outlined in Diagnostic Tools. The product documentation also includes a Troubleshooting section.

      Regards, Ian
      P.S Both the comments on these pages, and the dWAnswers forum are very much alive, and open to responses by IBM and non-IBM people. Currently, the IBM Betaworks team and project team are committed on immediate project deadlines so are a bit slower to respond. In future, we’ll try to keep commentors more aware.

      • Hi Ian,

        Thanks for the detailed answer, I’m very appreciated for that. Will be waiting for further updates from Betaworks team.

  44. Hi,
    Thank you very much for this useful labs.
    Please send me the information about how to get and use the IIB Log Viewer.

    Thanks & Regards,
    Abhishek

    • Hi Abhishek,
      I’ve sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  45. Colleagues,
    I’ve got the next error message on the final stage of map development:
    —————
    The type of the input or output “employeeNumber” of the submap refinement is incompatible with type “employeeNumberType” in submap “getEmployees_submap”. They must be the same or have a derived relationship.
    —————
    Is there a workaround for this issue? Got no clue what’s wrong with the map, I did everything in accordance to instructions.
    …and, is there a good ‘debugging guide’ around?

    • ILIYA Dimitrov February 16, 2017

      Hi Alex,

      Could you please provide more details on what are the types that you see for your employeeNumber and employeeNumberType?

      Thank you

  46. Hi,
    Thank you very much for this useful labs.
    Could you please send me the instructions to use IIB Log viewer?
    Thanks,
    Murari

    • Hi Murari,
      I’ve sent you an email about how to get and use the IIB log viewer.
      Regards, Ian

  47. Gourav Sukhija August 31, 2016

    I Have a valid Json which has no errors in swagger editor but it is not getting parsed in IIB-10.0.0.4 toolkit. Is it a Product Bug?

  48. I had a problem expanding servers IIB User Interface, the problem was that my browser is in Spanish. This is a bug of product styles IIB v.10.3

    • A solution at the moment is that the browser has established the English language

  49. Hello,
    When I linking a submap I am getting the following error.
    The type of the input or output “employeeNumber” of the submap refinement is incompatible with type “employeeNumberType” in submap “getEmployees_submap”. They must be the same or have a derived relationship.
    Thank you very much.

    • ILIYA Dimitrov February 16, 2017

      Hi Jonathan,
      Could you please provide more details on what are the types that you see for your employeeNumber and employeeNumberType?
      Thank you

  50. Thanks very much for a really interesting set of labs. May I also ask for the Log Viewer link please?

    • Hi Neville,
      I have sent you an email about how to get and use the IIB Log Viewer.
      Regards, Ian

  51. Hi Ian,
    Thank you very much for the labs.
    Could you please send me the instructions to use IIB Log viewer?
    Thanks,
    Wayne

    • Hi Wayne,
      I’ve sent you an email about how to get and use the IIB Log viewer.
      Regards, Ian

  52. LeonardoCosta July 21, 2016

    Hi,

    I would like to request the Windows Log Viewer files.

    Thanks for your attention!

    Regards,

    • Ian_Larner July 22, 2016

      Hi,
      I have sent you an email with instructions about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  53. Rajanmarins July 20, 2016

    Hi Ian,
    Thank you very much for the labs.

    Could you please send me the instructions to use IIB Log viewer?

    Thanks,
    Rajan

    • Ian_Larner July 20, 2016

      Hi Rajan,
      I’ve sent you an email with instructions about how to get and use the IIB log viewer.
      Regards
      Ian

  54. Hi Ian,

    Thank you very much for the labs.

    Could you please send me the instructions to use IIB Log viewer?

    Thanks,
    Rajan

    • Ian_Larner July 22, 2016

      Hi Rajan,
      I have sent you an email about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  55. Luis Felipe Bertel July 11, 2016

    For those who are getting this error, BIP5713E: A JSON writing error occurred. An invalid element, ‘xsi’, was found as a child of the root element

    Just add assign a value (0) to every single element in DBRespType inside the submap.in the same part where you set the RowRetrieved value.

    ERROR:
    500 Internal Server Error
    500 Internal Server Error
    BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.getEmployee (Implementation).getEmployee_REST’.
    BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.HTTP Reply’.
    BIP5706E: JSON writing errors have occurred.
    BIP5713E: A JSON writing error occurred. An invalid element, ‘xsi’, was found as a child of the root element. The element causing the problem is: ‘/Root/JSON/{http://www.w3.org/2000/xmlns/}:xsi’

    • Hi Luis,

      I am still getting the error any work around ?

      500 Internal Server Error

      500 Internal Server Error

      BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST2.getEmployee (Implementation).getEmployee_REST2’.
      BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST2.HTTP Reply’.
      BIP5706E: JSON writing errors have occurred.
      BIP5713E: A JSON writing error occurred. An invalid element, 'xsi', was found as a child of the root element. The element causing the problem is: '/Root/JSON/{http://www.w3.org/2000/xmlns/}:xsi'

      IBM Integration Bus v10.0.0.7

      • Miguel Ramirez April 04, 2018

        In order to work for this, yo must set the elements of the DBRespType in DBResp.xsd optional

        • gmadkins2 May 08, 2018

          Worked!! Thanks.

        • I am getting error:
          BIP5713E: A JSON writing error occurred. An invalid element, 'xsi', was found as a child of the root element.

          How do I fix this error?

  56. Hi Ian,

    Thanks very much for the Labs.

    Can you please also send me the Windows Log Viewer files?

    Thanks,

    • Ian_Larner July 11, 2016

      Hi,
      I’ve sent you an email with information about how to get and use the IIB Log Viewer (Monitor).
      Regards,
      Ian

  57. Luis Felipe Bertel July 07, 2016

    First of all, nice Lab.
    Could you please provide a link to the IIB Log Viewer.
    Thanks

    • Ian_Larner July 07, 2016

      Hi Luis,
      I have sent you an email with information about how to get and use the IIB Log Viewer.
      Regards,
      Ian

  58. Baidhya Nath Nayak July 04, 2016

    Hello Ian,
    Can you please send me the link for IIB log viewer. I want to try the lab exercise.

    • Ian_Larner July 04, 2016

      Hello Baidyha
      I’ve sent you an email with instructions on how to get and use the IIB Log Viewer.
      Regards
      Ian

  59. Quoc Tuan June 27, 2016

    Hello Ian,

    I’m getting the Error when try to test the service:

    Text:CHARACTER:An invalid element was found as a child of the root element Type:INTEGER:5 Text:CHARACTER:xsi Insert Type:INTEGER:5 Text:CHARACTER:/Root/JSON/{http://www.w3.org/2000/xmlns/}:xsi

    Can you help me to resolve this issue ?

    Thank you so much.

  60. Hello Ian,

    Can you please send me the link for IIB log viewer…

    • Ian_Larner June 13, 2016

      Hi,
      I have sent you an email with information about getting and using the IIB Log Viewer.
      Regards,
      Ian

  61. Hi,
    I am also facing same issue while running the REST API in swagger UI

    BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.getEmployee (Implementation).getEmployee_REST’.
    BIP3947E: The map processing for QName ‘{default}:getEmployee_REST'’ has failed, with the following details: ‘'XProcessException com.ibm.broker.xci.BrokerXCIException:

    IBM Integration Bus v10.0.0.4

    • Ian_Larner May 31, 2016

      @SOATech, @kalam, @Gilbert, @kskhong,
      Thanks for your comments, and sorry to hear you are having difficulties. We’re going to test the Lab before replying, but are really busy preparing for a new set of Lab workshops in the next few weeks so may not have the answer quickly.
      We’ll reply as soon as possible.
      Regards,
      Ian

    • Hi
      This is my work around : in the sub flow implementing the operation getEmployee, I added a compute node after the map node (getEmployee_REST) with the following ESQL :
      SET OutputRoot.JSON.Data=InputRoot.JSON.Data;

  62. Hi,

    When I linking a submap I am getting the following error.

    The type of the input or output “employeeNumber” of the submap refinement is incompatible with type “employeeNumberType” in submap “getEmployees_submap”. They must be the same or have a derived relationship.

    I think problem is with in the submap, but I did not made any changes to submap.

    Thanks and Regards
    Shaik Kalam

  63. Hello gentlemen,

    I want to test the EmployeeService REST API that I developed using the lab instructions. Can I use the online swagger UI tool or do I have to install it on my development machine? I tried testing with the online tool but I get the errors below. I don’t know if is related to using the online tool. Thanks.

    500 Internal Server Error

    500 Internal Server Error

    BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.getEmployee (Implementation).getEmployee_REST’.
    BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.HTTP Reply’.
    BIP5706E: JSON writing errors have occurred.
    BIP5713E: A JSON writing error occurred. An invalid element, 'xsi', was found as a child of the root element. The element causing the problem is: '/Root/JSON/{http://www.w3.org/2000/xmlns/}:xsi'

    IBM Integration Bus v10.0.0.4

    • Getting this error after following LAB.Any Suggestion

      BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.getEmployee (Implementation).getEmployee_REST’.
      BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService_REST.HTTP Reply’.
      BIP5706E: JSON writing errors have occurred.
      BIP5713E: A JSON writing error occurred. An invalid element, ‘xsi’, was found as a child of the root element. The element causing the problem is: ‘/Root/JSON/{http://www.w3.org/2000/xmlns/}:xsi’

    • I got the same error; whether using SOAP UI or the Swagger testing tool. Have you resolved the problem?

      Also note that if I use the solution workspace – everything is working fine.

      • I had the same problem with extra ‘xsi’ in JSON output. I got it working by adding another mapping node that moves the Data Object into map output. That filters out the ‘xsi’ attribute.

  64. Hi

    Thanks a lot for those labs it’s a great effort.
    can you please send me the IIB Event log monitor

    • Ian_Larner April 12, 2016

      Fadi,
      Thanks for the comments.
      I’ve sent you an email with information about how to get and use the IIB Log Viewer.

  65. Thanks very much for the informative article. I have 2 questions
    1) IIB V10 documentation say that REST API can be created from scratch without using swagger , but in the IIB toolkit when I tried to create, it does not allow without specifying the swagger document location.

    2) Please provide the link for Windows IIB monitor

    Thanks

    • Ian_Larner March 22, 2016

      Hi Rajeev,
      Thanks for your comments.
      For 1) You can create a Rest API from scratch, by File > New > REST API, and then selecting the default option “Create a REST API and define resources and operations yourself”. After finishing the new wizard, you then define resources, models, and operations, and implement those operations yourself. All this is described in IBM Knowledge Center starting with “Creating a REST API from scratch by using the IBM Integration Toolkit” (https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bi12036_.htm) and continuing with other task pages linked from that main page.
      (I just tested this with IIB 10.0.0.4.)

      For 2), I have sent you an email with the Log Viewer files attached.

      Regards,
      Ian

      • Hi Ian,

        Thanks very much for the Labs, man you are a life saver and someone who is helping people learn and get better in their lives.

        Can you please also send me the Windows Log Viewer files? which are shipped separately?

        Thanks,

        • Ian_Larner April 05, 2016

          Hi Sam,
          Thanks for your comments! I’ve passed them on to the Betaworks team here who created the Labs, and use them to run Lab classes here at IBM Hursley.

          I’ve sent you an email with information about how to get and use the IIB Log Viewer.

  66. I believe there is an issue with the links here. I am unable to download the lab or the instructions. I have attempted using both IE and Chrome.

Join The Discussion

Your email address will not be published. Required fields are marked *