Field Service

Get Involved. Join the Conversation.

Topic

    Mohana Gopal Selvam
    Daily Extract
    Topic posted May 2, 2018 by Mohana Gopal SelvamSilver Crown: 22,500+ Points 
    90 Views, 8 Comments
    Title:
    Daily Extract
    Content:

    Hi All,

    Instead of download of records can we push the data to another system using Daily extract?

    Thanks,

    Madhu

    Comment

     

    • Zsolt Tolgyesi

      Hi Madhu,

      The Daily Extract functionality is pack the previous day's data into XML files and made available through REST access. If your another system is able to get and progress data in this fashion, then yes, but I don't think it's can be done without some development.
      Or you can extend the activity flow to send activity details to an external system for storage reason, but I think this isn't wort the effort.

      Regards,
      Zsolt

    • Luuk

      Out of the box there's no such thing as a daily export.
       

      - You have some options: set an escalation rule and run a custom process for each object

      - Create a report and plan it. Send the planned report using the report scheduler to an email.

      - Retrieve the info from the external system via the API's 

      - Ask Oracle to put some script on the servers that run every x period.

    • Thiyag

      Hi Lukk,

      Thanks for the response.

      -> 3rd point - here we want to export / send those extracted info to another system via API or using some other source.

      -> 4th point - Whether oracle support help us to do the same?

      your clarification on those points are highly appreciated.

      Regards,

      Thiya

       

       

    • Luuk

      -> 3rd point - here we want to export / send those extracted info to another system via API or using some other source.

      This is the other way around. You'll need to use the external system to RETRIEVE the info instead of SENDING it from Oracle Service Cloud.
      This can either be done via the REST API or via the SOAP API. Full documentation is available here: https://cx.rightnow.com/app/answers/detail/a_id/5169

      -> 4th point - Whether oracle support help us to do the same?
      Oracle has some ways of running something like cronjobs. 

    • Anuj Behl

      Hi Thiya,

      Since this post is in Field service forum, I assume you want to extract field service data. If yes, you should look at Zsolt's answer as Luuk's answer is more focussed on extracting data from OSC.

      -Anuj

    • Thiyag

      Hi Lukk,

      Thanks for briefing.

      Hi Anuj,

      Yes, as you said the expectation is to get the field service data to store it in some other system. Since OFSC data will not be there in 90 days so we require an alternate for this thing.

      Thanks

      Thiya

       

    • Mohana Gopal Selvam

      Can we select specific custom fields and then send it to 3rd party system? 

    • Zsolt Tolgyesi
      Mohana Gopal Selvam said:

      Can we select specific custom fields and then send it to 3rd party system? 

      View original

      Better to start new topic when a new direction is appear, but yes you can specify different delivery channels and trigger messages with any fields included.
      Configuration / Message Scenarios & Channels