Populate Cases Module dropdown with API call

Dear All,

I am a developer totally new to sugar crm, so apologies if this doesn't make sense.

I have a cases module with dropdown fields added to a panel. I want to fill these fields by reading from an external rest api get endpoint during data entry, say if /search/id responds with {name: "client"}, I would like to update the name field to client as the data entry proceeds. My questions are:

- Can this be done from the module builder or the studio of the crm instance?

- If not, should this be done from the code of the deployed instance?

- Could someone kindly point me to the documentation I would follow to develop this?

Parents
  • Hello 

    Actually, you can configure all the stuff instead of spending time on Sugar development - external API calls and population data in Sugar - with the no-code tool Logic Builder.

    I have an example that corresponds to the task.

    There is Example1 sugar instance with Cases module, each Case records has ExternalCaseNumber and DropdownA fields.
    There is also  external system - Example2 , another sugar instance with extra Cases info (that could be any other system with rest API)
    I configured the following:  on Case record saved in Example1, to read the Case Status from Example2 with external call and depending on the value retrieved, decide to populate the DropdownA field  with value "Open" or "Closed"

    Here is the video:
    /cfs-file/__key/communityserver-discussions-components-files/54/ext12.mp4


    And here is the flowchart that configures Sugar instance Example1 to make this represented in the video.
    You can easily read the logic by following the white line (pls zoom in the picture to read):

    I suppose this flowchart could be easily adjusted - to adjust the start criterion, to deal with your Sugar custom data model and to retrieve from your external system with rest API available.

    Let me know if any questions about Sugar configuring.

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Reply
  • Hello 

    Actually, you can configure all the stuff instead of spending time on Sugar development - external API calls and population data in Sugar - with the no-code tool Logic Builder.

    I have an example that corresponds to the task.

    There is Example1 sugar instance with Cases module, each Case records has ExternalCaseNumber and DropdownA fields.
    There is also  external system - Example2 , another sugar instance with extra Cases info (that could be any other system with rest API)
    I configured the following:  on Case record saved in Example1, to read the Case Status from Example2 with external call and depending on the value retrieved, decide to populate the DropdownA field  with value "Open" or "Closed"

    Here is the video:
    /cfs-file/__key/communityserver-discussions-components-files/54/ext12.mp4


    And here is the flowchart that configures Sugar instance Example1 to make this represented in the video.
    You can easily read the logic by following the white line (pls zoom in the picture to read):

    I suppose this flowchart could be easily adjusted - to adjust the start criterion, to deal with your Sugar custom data model and to retrieve from your external system with rest API available.

    Let me know if any questions about Sugar configuring.

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Children
No Data