19
Views
2
Comments
i need to bulk insert the data's but i am added the file in resource how  we access
Question
Application Type
Reactive

Hi all,

I have one requirement i need to insert the more than 20k records 

{

    "totalSize": 280673,

    "done": false,

    "nextRecordsUrl": "/services/data/v58.0/query/0r8xx24jBrEaNAPAI3-2000",

    "records": [

        {

            "attributes": {

                "type": "Opportunity",

                "url": "/services/data/v58.0/sobjects/Opportunity/0061T00000m8Cg3QAE"

            },

            "Id": "0061T00000m8Cg3QAE",

            "Name": "Advanced Services-Europa Sports Products - 1 year broadband",

            "StageName": "Deal Won",

            "Owner": {

                "attributes": {

                    "type": "User",

                    "url": "/services/data/v58.0/sobjects/User/00550000006uVD2AAM"

                },

                "Name": "Paul Summers"

            },

            "Account": {

                "attributes": {

                    "type": "Account",

                    "url": "/services/data/v58.0/sobjects/Account/0011T00001tnx6DQAQ"

                },

                "Name": "Europa Sports Partners"

            },

            "Amount": 1063.96,

            "CloseDate": "2019-03-11",

            "Quote_ID__c": "SQ-00056222",

            "Agent_Manager__r": {

                "attributes": {

                    "type": "User",

                    "url": "/services/data/v58.0/sobjects/User/00550000006uVD2AAM"

                },

                "Name": "Paul Summers"

            },

like this but i need add this file. this file is actual response of API from some where now i need added this file in resource and then i need to add that files in my local entity how we can do this i am planned to use bulk insert can you any one help me achieve this with you idea along with bulk insert.



also how we can access that resource file how ?


Hi, 


Please check below forge component. 

you can use it to perform bulk insert operation 

https://www.outsystems.com/forge/component-overview/1117/bulkinsert

I have tried this for inserting 5 lakh + records, it works very well 

do you try with adding the file with  resource  if you don't mine could you share any OML for my learning 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.