• junlia
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hello,

Brand new to Apex  - Day 1. I wanted to create a job to bulk load data into SF. But I am getting this error when creating the job in workbench:

 Response
[ {
  "errorCode" : "API_ERROR",
  "message" : "Unexpected character ('-' (code 45)) in numeric value: expected digit (0-9) to follow minus sign, for valid numeric value at [line:1, column:3]"
} ]

Here is the request header:
Content-Type: application/json; charset=UTF-8
Accept: application/json

and here is the request body:
--BOUNDARY
Content-Type: application/json
Content-Disposition: form-data; name="job"

{
  "object":"Contact",
  "contentType":"CSV",
  "operation": "upsert"
  “lineEnding”: “CRLF”

}

--BOUNDARY
Content-Type: text/csv
Content-Disposition: form-data; name="content"; filename="content"

FirstName,LastName,Title,Description
Tom,Jones,Senior Director,Self described as the top branding guru on the West Coast
Ian,Dury,Chief Imagineer,World renowned expert in fuzzy logic design
Tom Jr,Jones,Director, branding guru on the West Coast
Ian Jr,Dury,Imagineer,learn from dad  in fuzzy logic design
--BOUNDARY--

Any pointer on what exactly is it complaining about?

Thanks much
  • November 15, 2018
  • Like
  • 0
Hello,

Brand new to Apex  - Day 1. I wanted to create a job to bulk load data into SF. But I am getting this error when creating the job in workbench:

 Response
[ {
  "errorCode" : "API_ERROR",
  "message" : "Unexpected character ('-' (code 45)) in numeric value: expected digit (0-9) to follow minus sign, for valid numeric value at [line:1, column:3]"
} ]

Here is the request header:
Content-Type: application/json; charset=UTF-8
Accept: application/json

and here is the request body:
--BOUNDARY
Content-Type: application/json
Content-Disposition: form-data; name="job"

{
  "object":"Contact",
  "contentType":"CSV",
  "operation": "upsert"
  “lineEnding”: “CRLF”

}

--BOUNDARY
Content-Type: text/csv
Content-Disposition: form-data; name="content"; filename="content"

FirstName,LastName,Title,Description
Tom,Jones,Senior Director,Self described as the top branding guru on the West Coast
Ian,Dury,Chief Imagineer,World renowned expert in fuzzy logic design
Tom Jr,Jones,Director, branding guru on the West Coast
Ian Jr,Dury,Imagineer,learn from dad  in fuzzy logic design
--BOUNDARY--

Any pointer on what exactly is it complaining about?

Thanks much
  • November 15, 2018
  • Like
  • 0